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

182 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
detecter1129873(None) 
detected12289731detected
detecters12217751detecters
detector11278321detector
detester9239681detester
decenter112412162decenter
defeater122611662defeater
defected15289972defected
defector14277952defector
dejected19307592dejected
depicter1356852depicter
deserter91211602deserter
detacher1437542detacher
detect94217402detect__
detectors12278302detectors
detects104011092detect_s
detente83313602detente_
detentes92712872detentes
deterger10147592deterger
deterrer9137012deterrer
detested10279622detested
detesters10298302detesters
deticker1545282deticker
directer1137582directer
erecter93113392_erecter
rejecter17258942rejecter
affecter1644523affecter
anteater8311603anteater
attester836503attester
begetter11136313begetter
besetter10137973besetter
betatter1035453betatter
better84723703bet__ter
cementer1239193cementer
debater104114693de_bater
decanter112510793decanter
deceiver1436233deceiver
decenters122410373decenters
decentre11248553decentre
decker135215993d__ecker
decocted1437683decocted
deducted1356243deducted
deedier93011593de_edier
deemster1175713deemster
deeper93613503de_e_per
defacer132810363defac_er
defeated132812163defeated
defeaters13289103defeaters
defecate1438793defecate_
defecated1637493defecated
defecates1538593defecates
defecator1546383defecator
defect124816173defect__
defectors15237883defectors
defects134511523defect_s
defender1337293defender
deferrer12135593deferrer
deflater123211603deflater
deflected1635983deflected
deflector1555063deflector
defter104215923d__efter
degender1136893degender
deicer94114413de_ic_er
deject164512843deject__
dejecta17376363deject_a
dejects17389223deject_s
dejeuner1682933dejeuner
delete73620703dele_te_
deleted93314913dele_ted
deletes83117933dele_tes
deluster936903deluster
demented12311273demented
demerger12127373demerger
demister11310223demister
dempster1355773dempster
depicted1437743depicted
depicters1435823depicters
depictor1355513depictor
depleter11298863depleter
deporter1169393deporter
desalter938363desalter
desecrater1346983desecrater
deserted101012203deserted
deserters10129983deserters
deserver12118383deserver
detached1537733detached
detachers1536483detachers
detaches1439653detaches
detailer9268673detailer
detainer92910793detainer
detecting13259983detecting
detection121310413detection
detective1548103detective
detectives1645783detectives
detent73624483detent__
detents83615153detent_s
deter65028043d__e_ter
deterge9118463deterge_
deterged11127923deterged
detergers11147183detergers
deterges101510093deterges
deterred10137803deterred
deterrers10116593deterrers
detest74122843detest__
detests83711743detest_s
deticked1635693deticked
detickers1634423detickers
detracted1357793detracted
detractor12147213detractor
devested13239133devested
devouter1235513devouter
dewater112912423de_water
dexter143810893d__exter
diester83013683d_iester
dieter73516773d_ie_ter
digester10258433digester
dimeter10411893dime_ter
directed1238233directed
director1147773director
ditcher134012003dit_cher
diverter12238623diverter
dopester1137253dopester
dotter74419343dot__ter
effecter1664773effecter
ejected17297653_ejected
ejector16378603_ejector
elected102812613_elected
electee92513243_electee
elector93313253_elector
erected103213993_erected
erecters102611613_erecters
erector93513803_erector
etcetera1043183_etcetera
etcher113912943_et_cher
exacter1637403_exacter
executer1745313_executer
expecter1936513expecter
fetcher153510393fet_cher
fetter94120383fet__ter
getter74117613get__ter
infecter13229153infecter
keester11319913ke_ester
letter63722583let__ter
meeter83616503me_e_ter
neglecter1263633neglecter
netter63722023net__ter
obtected1344553obtected
perfecter1646043perfecter
petter83924773pet__ter
protecter13179103protecter
recenter102715443recenter
reenter73217793re_enter
refected142311663refected
reheater113413033reheater
rejected182710113rejected
rejectee17289623rejectee
rejecters18257543rejecters
rejector17237723rejector
reletter81311023reletter
repeater102615443repeater
repenter102813863repenter
resected112514743resected
resetter81511833resetter
respecter1347443respecter
retemper1235183retemper
retested92212533retested
retorter8410733retorter
retreater9310203retreater
reverter114812873reverter
selected1159783selected
selectee10910493selectee
selector1048603selector
semester1038903semester
setter64023723set__ter
specter113111733_specter
teeter65420313__teeter
tenter64623933__tenter
tester64227153__tester
tetter64322453__tetter
undetected1444873undetected
vetter93417643vet__ter
wetter93919443wet__ter

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.546327272.9
2DLD Change Limit1461621828.26617682.3
3Display Results1821820.0931957.0
 (SQL Overall)1786911828.90520066.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.