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 “restables” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

170 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
restables11151142(None) 
restable101618441restable_
restabled12148961restabled
retables101712671re_tables
eatables10169792_eatables
gustables12165222gustables
nestable101613672nestable_
ratables10159722r_atables
reliables1145902reliables
rentable101716332rentable_
resales74724902res_a_les
rescales103414572resca_les
resembles1376072resembles
restages92815772resta_ges
restates83423442resta_tes
restyles1139192rest_yles
retable91820402re_table_
reusables1175222reusables
rustable101511362rustable_
stables93219072__stables
testable101412622testable_
beatable121612243beatable_
breakables1842753breakables
cascables15165773cascables
castable121613973castable_
constables1446733constables
creatable1339563creatable_
desirables1344213desirables
disables11410903dis_ables
eatable91717603_eatable_
enables92813123_e_nables
erectable131210093erectable_
establish1444743_establish
estates74520183_esta_tes
gestalts955493gesta_lts
gestates93213733gesta_tes
getable101712553ge_table_
gettable11178133gettable_
giftables1572593giftables
gustable11138203gustable_
heatable131612043heatable_
instable10313203instable_
listable10810313listable_
meltable12310473meltable_
nestles73015463nest__les
nettable101610243nettable_
notables10178243_notables
obstacles1343713obstacles
pentacles1338773pentacles
pestholes1448233pestholes
pestles93217693pest__les
pettable121710713pettable_
portables1337873portables
potables12179703_potables
presales10315263pres_a_les
ratable91717553r_atable_
readable11313163readable_
reales64934123re__a_les
reapable12311393reapable_
rectangles1344003rectangles
redoubles1244263redoubles
redtails968003redtail_s
reefable1339533reefable_
reelable10311603reelable_
reestablish1653103reestablish
refutable1477863refutable_
regales83520793re_ga_les
relabels1045343re_labels
relatable11310053relatable_
reliable10313073reliable_
renewables1543403renewables
rentals74017483renta_l_s
reptiles103913073rept_iles
reputable1379123reputable_
resaddles11114693resaddles
resailed93613063res_ailed
resails74616743res_ail_s
resalable1138733resalable_
resale64025543res_a_le_
resamples1344713resamples
rescale93215483resca_le_
rescaled113311303resca_led
rescuable1347583rescuable_
resealed92713973resea_led
reseals73917683resea_l_s
resectable1478123resectable_
resemble1247313resemble_
resembled1445173resembled
resembler1344583resembler
resemblers1443413resemblers
resettable1256513resettable_
resettles936563resettles
reshapes1338803resha_pes
reshaves1438733resha_ves
resiles74026543res__iles
reslates83619513resla_tes
resoles73823653res__oles
respaces12311043respa_ces
respades1139853respa_des
respectables1873033respectables
restabilizes2364623restabilizes
restabling1337653restabling
restacked1636483restacked
restacks1438093resta_cks
restaffed1653753restaffed
restaffs1444783resta_ffs
restage83316193resta_ge_
restaged103011863resta_ged
restamped1444433restamped
restamps1234703resta_mps
restarted10410053restarted
restarts8310873resta_rts
restate73824883resta_te_
restated93120183resta_ted
restless82713163rest__less
restokes125213043rest_okes
restorable1246753restorable_
restores85222993rest_ores
restrikes1339413restrikes
restrives12310663restrives
restudies10156033restudies
restyle1038763rest_yle_
restyled1236953rest_yled
resumable1347553resumable_
retackles1545363re_tackles
retailed94113963re_tailed
retailer82911573re_tailer
retailers9258773re_tailers
retails74718973re_tail_s
retakes113718863re_ta_kes
retallies939373re_tallies
retapes93917423re_ta_pes
retastes82212903re_tastes
retaxes143615093re_ta_xes
reticles103912483re_ticles
retiles74426993re_t_iles
retitles83612593re_titles
reusable10811273reusable_
risibles1035783ris_ibles
rustles73416413rust__les
sables85026693__s_ables
stabiles10311403__stabiles
stable83921643__stable_
stabled103514953__stabled
stabler94014933__stabler
stablers103611153__stablers
stablest103312943__stablest
stales65538293__sta_les
staples93617213__staples
tables84524893___tables
tastable101511973tastable_
tentacles1146713tentacles
testacies1148373testacies
testates83615453testa_tes
testicles1146773testicles
treatable1139323treatable_
trestles83012553trest__les
trustable1147123trustable_
unstable10313763unstable_
unstabler1145623unstabler
unstablest1244183unstablest
vegetables1642703vegetables
vendables15165153vendables
vestals104612333vesta_l_s
vestibules1543603vestibules
washables17144743washables
wastable131410453wastable_
wearables14155013wearables
wettable13148043wettable_
wrestles113310063wrest__les

Search took 9 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.440406115.9
2DLD Change Limit1486411707.95318689.9
3Display Results1701700.0762236.8
 (SQL Overall)1786911708.46921099.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.