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

147 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
diverter1223862(None) 
diverted13199581diverted
diverters13227871diverters
averter102410552_averter
deserter91211602deserter
diester83013682di_ester
dieter73516772di_e_ter
digester10258432digester
dimeter10411892dime_ter
directer1137582directer
diverge12347642diverge_
diverged14256882diverged
diverges13258312diverges
diverse11429992diverse_
divert103922812divert__
diverts114412032divert_s
divested13268212divested
divorcer1444032divorcer
inverter112411072inverter
reverter114812872reverter
riveter10208752rive_ter
adverted1336103adverted
alerter72111513_alerter
asserter877573asserter
averted112211613_averted
averters11249513_averters
bimester1236163bimester
cavorter1335783cavorter
converter14311013converter
coverer123113523cover_er
coveter122912063cove_ter
darter75320363d__arter
decenter112412163decenter
defeater122611663defeater
deferrer12135593deferrer
defter104215923d__efter
deliverer1344503deliver_er
demerger12127373demerger
deporter1169393deporter
deserted101012203deserted
deserters10129983deserters
deserver12118383deserver
detecter11298733detecter
deter65028043d__e_ter
deterger10147593deterger
deterrer9137013deterrer
detester9239683detester
devested13239133devested
devouter1235513devouter
dexter143810893d__exter
diameter1148053diameter
diaster82813313di_aster
diesters92513603di_esters
dieted83115493di_e_ted
dieters83216433di_e_ters
diether1147443di_ether
digested11208163digested
digesters11257883digesters
digestor10246553digestor
dilater83515653di_later
diluter8319663di_luter
dimeters11411093dime_ters
dinette8310013dinette_
dinettes9310193dinettes
diopter1038473di_opter
directed1238233directed
director1147783director
direr64927073di__r_er
dirtier83312093di__rtier
disarmer1138033disarmer
disaster949943disaster
discerner1246943discerner
disinter9310673disinter
disorder1038133disorder
disperser12109083disperser
disputer1137973disputer
dissenter1059133dissenter
disserted11109813disserted
distorter1048403distorter
ditherer12187763dither_er
diver94827803div___er
divergent1447363divergent
divers105024963diver__s
diversely1643963diversely
diverting142410333diverting
divest106820073divest__
divests114510933divest_s
divesture13144183divesture
divider12278953div_ider
diviner11369883div_iner
divorce1344813divorce_
divorced1544313divorced
divorcee1444673divorcee
divorcers1543693divorcers
divorces1445673divorces
divulger1342553divulger
dopester1137253dopester
driveler1284693drive_ler
driveller1353853driveller
everted112711853_everted
evertor1038723_evertor
fiercer12356953fi_ercer
fierier103511193fi_erier
figeater1236953figeater
hoverer13319823hover_er
inserter82312133inserter
inventer112410843inventer
inverted122312163inverted
inverters12239753inverters
invertor11238973invertor
kiester11329973ki_ester
livelier1136873livelier
livener10278943live_ner
livered113111633liver_ed
liveried1238733liveried
liveries11314373liveries
misenter10310833misenter
miterer92511333miter_er
obverted1435103obverted
perter84422283__perter
perverter1445563perverter
piercer11337773pi_ercer
quiverer2044463quiver_er
reverer103815833rever_er
reverser113010483reverser
reverted122714713reverted
reverters122710433reverters
rimester1037813rimester
riverbed14245143riverbed
riveted11258573rive_ted
riveters11228163rive_ters
rivetted12226093rivetted
severer103511563sever_er
shiverer14186663shiver_er
silenter838873silenter
silverer11216733silver_er
sliverer11237633sliver_er
subverter1445273subverter
svelter10359673_svelter
taverner1134423taverner
venter94218723__venter
verger104315703__verger
verier94620963__verier
verser94516963__verser
vertex1637373__vertex
vetter93417643__vetter
waverer13319523waver_er

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.423422437.4
2DLD Change Limit1461621476.98320931.1
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.46923924.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.