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 “dispatchers” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
dispatchers197246(None) 
dispatcher1853261dispatcher_
dispatches1874581dispatche_s
despatches1874042despatche_s
dispatched1993882dispatche_d
mispatches1974102mispatche_s
despatched1953233despatche_d
disparagers1553393disparagers
dispatch1654553dispatch___
dispatching20143523dispatching
displacers1545013displac_ers
disputers1236613disput__ers
ditchers143610363di___tchers
dogcatchers2051603dogcatchers
mismatches1953753mismatche_s
mispatched2053833mispatche_d
patchers153413303___patchers
snatchers14146313__snatchers
batchers153613274___batchers
bespatters1442784bespat_ters
catchers153114064___catchers
cowcatchers2051564cowcatchers
debauchers18122644d_ebauchers
despairers1343104despa_irers
despatch1643224despatch___
despatching20122654despatching
detachers1536484d_eta_chers
dethatches1943194dethatche_s
diethers1257454di__et_hers
dilaters92513064di_lat__ers
diopters1137694diop_t__ers
disablers1255804dis_a_blers
disarmers1246944dis_a_rmers
disasters1039154dis_a_sters
disavowers1743024dis_avowers
disbranches1953524disbranche_s
discarders1445044disca_rders
disgracers1444734disgrac_ers
dishwashers2151604dishwashers
dishwaters1744024dishwat__ers
disinters1039714disint__ers
disparager1444394disparager_
disparages1446044disparage_s
dispellers13115444disp_ellers
dispensers13146744disp_ensers
dispersers13137424disp_ersers
displacer1446434displac_er_
displaces1448594displac_e_s
displayers1654824disp_layers
disposers1238374disp__osers
dispraisers1443424dispraisers
disprovers16145284disp_rovers
disputer1137974disput__er_
disputes1139654disput__e_s
disrates91118154disrat__e_s
dissipaters1453474dissipat__ers
distances12311654distanc_e_s
ditcher134012004di___tcher_
ditches133215714di___tche_s
dithers114016154di___t_hers
dogcatcher1952014dogcatcher_
dogwatches2042214dogwatche_s
dowitchers1942134d_owitchers
flycatchers245944flycatchers
hatchers163113174___hatchers
hitchers16379994hi___tchers
impacters15305484_impa_cters
impeachers1942694_impeachers
ingathers1344454_ingat_hers
matchers153012434___matchers
midwatches2141804midwatche_s
mismatched2063404mismatche_d
mispatch1743854mispatch___
mispatching21133434mispatching
patcher143515144___patcher_
patches143320384___patche_s
pistaches1646674pista_che_s
pitchers153211484___pitchers
repatches1636714_repatche_s
researchers1652204researchers
satchels13328164__s_atchels
scratchers1744294_scratchers
scutchers16175644__scutchers
searchers14197354__searchers
sketchers1834514__sketchers
slatches131511524__slatche_s
slathers113914784__slat_hers
snatcher13167764__snatcher_
snatches131410714__snatche_s
snitchers14166044__snitchers
spacers113813874__spa_c_ers
spathes125116534__spat_he_s
spatters103914704__spat_ters
stanchers14206814__stanchers
stitchers14147014__stitchers
swatches16169964__swatche_s
swathers144512084__swat_hers
switchers17146634__switchers
thatchers1744584__thatchers
watchers163511794___watchers

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 Filter1786911488190.1561145455.1
2DLD Change Limit1488191008.11018350.1
3Display Results1001000.0462173.9
 (SQL Overall)1786911008.31221498.0
 
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.