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

145 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
detachers153648(None) 
detacher1437541detacher_
detaches1439651detache_s
attachers14134882attachers
debauchers18122642debauchers
defacers14237992defac_ers
detached1537732detache_d
detailers10257252detailers
detainers10269102detainers
detecters12217752detecters
detickers1634422detickers
ditchers143610362dit_chers
etchers123411292_et_chers
fetchers16328862fet_chers
leachers133712812le_achers
peachers153213842pe_achers
reachers133515722re_achers
teachers133212392te_achers
aethers103614943aet__hers
attacher13125713attacher_
attaches13137723attache_s
attackers15144013attackers
batchers153613273bat_chers
beaches144120653be_ache_s
belchers153510023be_lchers
benchers153611013be_nchers
betatters1134963betatters
bleachers16297923bleachers
botchers153511543bot_chers
breachers16369853breachers
broachers16328153broachers
butchers153710183but_chers
catchers153114063cat_chers
coachers154312303_coachers
dackers143417043d__ackers
dashers115016863d__ashers
dealers84118613de_a_lers
deashes113313903de_ashe_s
debacles1335723debacle_s
debarkers16164553debarkers
debasers11377903deba_sers
debaters113511923deba_ters
debauchees18122043debauchees
debaucher17123293debaucher_
debauchery21131493debauchery
debauches17124063debauche_s
decanters12229223decanters
decayers14307963deca_yers
deciphers1744393deciphers
deckers144413833de__ckers
defacer132810363defac_er_
defaces133213403defac_e_s
defamers14258523defa_mers
degassers11354833degassers
deicers103612733de_ic_ers
delayers12268663dela_yers
demanders13247573demanders
demarches1745913demarche_s
depicters1435823depicters
derangers1136703derangers
desalters1037673desalters
detach12310413detach___
detachedly2052083detachedly
detaching1637263detaching
detachment1845883detachment
detachments1954593detachments
detailer9268673detailer_
detainees10267153detainees
detainer92910793detainer_
detassels1042673detassels
detecter11298733detecter_
detectors12278303detectors
detergers11147183detergers
deterrers10116593deterrers
deters74724683det___ers
detesters10298303detesters
dethatches1943193dethatche_s
deticker1545283deticker_
detractors13147293detractors
dewaters122910723dewa_ters
diethers1257453diet__hers
ditcher134012003dit_cher_
ditches133215713dit_che_s
dithers114016153dit__hers
drenchers15296103drenchers
etcher113912943_et_cher_
etches114217763_et_che_s
ethers94518413_et__hers
exacters1736773_exacters
feathers143513243fe_athers
fetcher153510393fet_cher_
fetches153413893fet_che_s
fetiches1636953fetiche_s
fletchers17335533flet_chers
hatchers163113173hat_chers
heathers143914733he_athers
hitchers16379993hit_chers
ketches164012193ket_che_s
kvetchers2142373kvet_chers
leacher124014843le_acher_
leaches123319343le_ache_s
leathers114215083le_athers
lechers123313963le__chers
letches124015483let_che_s
matchers153012433mat_chers
menacers12279313menac_ers
metamers1249623meta_mers
metaphors1645683metaphors
notchers13279423not_chers
patchers153413303pat_chers
peacher144216073pe_acher_
peaches144120053pe_ache_s
perchers153611523pe_rchers
pitchers153211483pit_chers
poachers152910763_poachers
preachers16339573preachers
reacher123718293re_acher_
reaches123423203re_ache_s
regathers1336353regathers
retailers9258773retailers
retainers92510763retainers
retakers123511133reta_kers
retarders10227573retarders
retches123318513ret_che_s
reteaches1437123reteache_s
retouchers1543483retouchers
retracers11149553retrac_ers
searchers14197353searchers
sketchers1834513sket_chers
snatchers14146313snatchers
stackers143413563_stackers
stanchers14206813_stanchers
taches114224173__tache_s
tackers134319623__tackers
teacher123714833te_acher_
teaches122718353te_ache_s
tethers103815313tet__hers
thatchers1744583thatchers
tochers123413093__tochers
vetches153411263vet_che_s
watchers163511793wat_chers
weathers143412833we_athers
welchers16338053we_lchers
wenchers16319213we_nchers
wethers135214693wet__hers

Search took 7 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 Limit1486411456.50322857.3
3Display Results1451450.0602416.7
 (SQL Overall)1786911456.98325589.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.