Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “refusable” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
refusable147668(None) 
refutable1477861refutable
reusable10811271re_usable
perusable1347452perusable
referable1439622referable
refinable1438622refinable
refundable1643802refundable
refusal1056892refusa_l_
refusals1164912refusa_ls
refutably1785332refutably
regulable1246512regulable
reputable1379122reputable
resumable1347552resumable
reusables1175222re_usables
revisable1437992revisable
abusable1236373_abusable
accusable1544873accusable
amusable1237143_amusable
arousable1145573arousable
causable1239973_causable
definable1547773definable
demisable1448533demisable
deposable1446833deposable
deputable1487043deputable
devisable1546853devisable
educable1337093_educable
effable15106673_ef_fable
equable1849253_equ_able
erasable10511043_erasable
excusable2044373excusable
focusable1644103focusable
fusible1237023__fusible
infusible1445923infusible
irrecusable1554053irrecusable
irrefutable1653983irrefutable
leasable101510133le_asable
nonusable1146763nonusable
preferable1746723preferable
presumable1645203presumable
raisable10311643r_aisable
reachable16129653reachable
readable11313163re_adable
reapable12311393re_apable
rebuttable1443953rebuttable
reclosable1444893reclosable
recoupable1645023recoupable
recusal968673recusa_l_
recusals1056393recusa_ls
reducible1444693reducible
reefable1339533re_efable
reelable10311593re_elable
refillable1544073refillable
reformable1745293reformable
refuse94817513refus___e
refutal1046943refuta_l_
refutals1165503refuta_ls
relatable11310053relatable
relaxable1836363relaxable
releasable1245483releasable
relegable1258103relegable
reliable10313073re_liable
relishable1544523relishable
relivable1438513relivable
removable1646923removable
renewable1447433renewable
rentable101716333re_ntable
reparable1359953reparable
repayable1666343repayable
reputably1686453reputably
resalable1138733resalable
resale64025543re__sa_le
rescuable1347583rescuable
restable101618443re_stable
retable91820403re__table
returnable1244793returnable
reverable14310363reverable
revivable1736863revivable
revocable1647003revocable
revokable1845293revokable
rinsable10310043r_insable
rulable9310533r__ulable
rustable101511363r__ustable
securable1347773securable
seisable10311373se_isable
teasable101511173te_asable
tenurable1147423tenurable
unusable1038953_unusable
usable84012553___usable

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.420425454.8
2DLD Change Limit148641886.81321817.3
3Display Results88880.0461913.0
 (SQL Overall)178691887.27924548.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.