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 “resettle” 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.

106 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
resettle83730(None) 
presettle1145941presettle
resettled1035301resettled
resettles936561resettles
presettled1344082presettled
presettles1245022presettles
rebottle1044342rebottle
resemble1247312resemble
resettable1256512resettable
resetter81511832resetter
restyle1038762res_tyle
rosette7310372rosett_e
settle63915662__settle
unsettle866062unsettle
beetle8311673be_e_tle
belittle1044053belittle
besetter10137973besetter
casette9310393casett_e
fettle93713123__fettle
freestyle1542603freestyle
frisette1195483frisett_e
genette838863genett_e
grisette994653grisett_e
kettle104311613__kettle
mettle83815723__mettle
musette938433musett_e
nestle63013953nes__tle
nettle64514583__nettle
pestle83215843pes__tle
pettle84116053__pettle
prebattle1343013prebattle
presentee11411863presentee
presently1449053presently
rattle64717613r__attle
rebottled1243433rebottled
rebottles1143873rebottles
recently1339423recently
rejectee17289623rejectee
reletter81311023reletter
repeople1245063repeople
reptile93914083re_ptile
resaddle10115223resaddle
resale64025543res__ale
resample1244673resample
rescale93215473res_cale
reseal64819643rese_al_
resealed92713963rese_aled
reseals73917663rese_als
reseat64131493reseat__
reseated93220263reseated
reseats74319583reseat_s
resect84424703resect__
resectable1478123resectable
resected112514743resected
resects94115593resect_s
resecure1047183resecure
resee54336333rese___e
reseize1639553rese_ize
resell64215203rese__ll
reseller83412223rese_ller
resells73313203rese_lls
resembled1445173resembled
resembler1344583resembler
resembles1376073resembles
resent63833623resent__
resented92716963resented
resentive12410723resentive
resents74221223resent_s
reserve101011203rese_rve
reset55051863rese_t__
resets65427613rese_t_s
resetters9129463resetters
resetting102816293resetting
resettling1135893resettling
resile64627673res__ile
resite64128453res_it_e
reslate73520593reslat_e
resole64624183res__ole
respite9513033respit_e
restable101618443restable
restage83316193res_tage
restate73824883res_tate
restive10315933res_tive
restoke116113903res_toke
restore75822973res_tore
restyled1236943res_tyled
restyles1139193res_tyles
retile65929673r__etile
retitle73913093re_title
reveille1145333reveille
revetted122210943revetted
rewetted12228353rewetted
roseate7613453roseat_e
roselle7310243rose_lle
rosettes8310343rosettes
rustle63615413rus__tle
settee63721023__settee
settled83210873__settled
settler73410653__settler
settles73916003__settles
teakettle1351483teakettle
trestle72611363tres__tle
unsettled1055213unsettled
unsettles964653unsettles
vedette1166003vedett_e
wrestle10298843wres__tle

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621067.83018666.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.04922200.4
 
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.