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

178 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
detacher143754(None) 
detached1537731detached
detachers1536481detachers
detaches1439651detaches
attacher13125712attacher
debaucher17123292debaucher
defacer132810362defac_er
detach12310412detach__
detailer9268672detailer
detainer92910792detainer
detecter11298732detecter
deticker1545282deticker
ditcher134012002dit_cher
etcher113912942_et_cher
fetcher153510392fet_cher
leacher124014842le_acher
peacher144216072pe_acher
reacher123718292re_acher
teacher123714832te_acher
aether94213673aet__her
attache12106693attache_
attached14165703attached
attachers14134883attachers
attaches13137723attaches
attacker14144983attacker
batcher144414853bat_cher
beached154516553be_ached
beaches144120653be_aches
beachier1538803be_achier
belcher143511493be_lcher
bencher144113483be_ncher
betatter1035453betatter
bleacher15358883bleacher
botcher143613223bot_cher
breacher153011503breacher
broacher15329263broacher
butcher143411163but_cher
catcher143115823cat_cher
coacher143714123_coacher
dacker134920753d__acker
dasher104318983d__asher
deader84220473de_a_der
deafer104114813de_a_fer
dealer74122143de_a_ler
dearer74822803de_a_rer
deashed123411303de_ashed
deashes113313903de_ashes
debacle1237443debacle_
debacles1335723debacles
debarker15155503debarker
debaser103510413deba_ser
debater104114693deba_ter
debauched18123343debauched
debauchee17123613debauchee
debauchers18122643debauchers
debauchery21131493debauchery
debauches17124063debauches
decanter112510793decanter
decayer13339353deca_yer
decipher1644423decipher
decker135215993de__cker
deface123113863defac_e_
defaced142910973defac_ed
defacers14237993defac_ers
defaces133213403defac_es
defamer132710323defa_mer
degasser10325813degasser
deicer94114413de_ic_er
delayer113010533dela_yer
demander12238723demander
demarche1645533demarche_
demarches1745913demarches
depicter1356853depicter
deranger1037353deranger
desalter938363desalter
detachedly2052073detachedly
detaching1637263detaching
detachment1845873detachment
detailed10319873detailed
detailers10257253detailers
detained103111643detained
detainee92511723detainee
detainers10269103detainers
detassel943653detassel
detected12289733detected
detecters12217753detecters
detector11278323detector
deter65028043det___er
deterger10147593deterger
deterrer9137013deterrer
detester9239683detester
dethatched2042533dethatched
dethatches1943193dethatches
deticked1635693deticked
detickers1634423detickers
detracted1357793detracted
detractor12147213detractor
dewater112912423dewa_ter
diether1147443diet__her
ditched143711903dit_ched
ditchers143610363dit_chers
ditches133215713dit_ches
dither104417683dit__her
drencher14257213drencher
etched123613703_et_ched
etchers123411293_et_chers
etches114217763_et_ches
ether84518773_et__her
exacter1637403_exacter
feather133613503fe_ather
fetched163710473fet_ched
fetchers16328863fet_chers
fetches153413893fet_ches
fetiches1636953fetiches
fletcher16306663flet_cher
hatcher153314723hat_cher
heather133914853he_ather
hitcher153712003hit_cher
ketches164012193ket_ches
kvetcher2052813kvet_cher
leached133715043le_ached
leachers133712813le_achers
leaches123319343le_aches
leachier1337253le_achier
leather103815783le_ather
lecher113415853le__cher
letched133912053let_ched
letches124015483let_ches
matcher143214283mat_cher
menacer112610883menac_er
metamer1139613meta_mer
metaphor1544913metaphor
nether94014163net__her
notcher123610933not_cher
patcher143515143pat_cher
peached154315883pe_ached
peachers153213843pe_achers
peaches144120053pe_aches
peachier1548623pe_achier
percher143313423pe_rcher
pitcher143813713pit_cher
poacher143912323_poacher
preacher153211373preacher
reached134619083re_ached
reachers133515723re_achers
reaches123423203re_aches
regather1236733regather
retacked15169273retacked
retailer82911573retailer
retainer82913813retainer
retaker113714313reta_ker
retarder9229433retarder
retched133814273ret_ched
retches123318513ret_ches
reteaches1437123reteaches
retoucher1444543retoucher
retracer101411883retrac_er
searcher13209103searcher
sketcher1735433sket_cher
snatcher13167763snatcher
stacker134416263_stacker
stancher13198813_stancher
tache106222373__tache_
taches114224173__taches
tacker124224503__tacker
teachers133212393te_achers
teaches122718353te_aches
tetched133010773tet_ched
tetchier1336453tet_chier
tether93716103tet__her
thatcher1635663thatcher
tocher114014913__tocher
vetches153411263vet_ches
watcher153113403wat_cher
weather133513223we_ather
welcher15319393we_lcher
wencher153811133we_ncher
wether123315393wet__her

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621787.31319986.6
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.53223724.2
 
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.