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

121 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
response103775(None) 
responsa1043591responsa
responses1147451responses
bespouse1245112bespouse
espouse936402_espouse
repose84121412re_po_se
reshone102414162reshon_e
respoke134311282respo_ke
respond1039112respon_d
responded1336512responded
responder1246452responder
responds1136912responds
responsive1553382responsive
responsum1352652responsum
respots92912762respots_
bespoke15468113bespo_ke
bespoused1443773bespoused
bespouses1345153bespouses
crepons1139323cre_pons_
depone93616553de_pon_e
depones103717093de_pones
depose94215763de_po_se
despise1038683desp_ise
despond1137513despon_d
desponded1445323desponded
desponds1246243desponds
despots10319683despots_
dispense11129783dispense
dispose10312763dispo_se
espoused1134863_espoused
espouser1044383_espouser
espouses1037303_espouses
expanse16145603_expanse
expense16127873_expense
expose1549523_expo_se
lesions73813873lesions_
lessons73811023lessons_
mesons83215843mes_ons_
mispoise1248263mispoise
nonresponse1353153nonresponse
prepense12238943pre_pense
rearouse839383rearouse
reasons72514943reasons_
rechoose13137353rechoose
rechose121312053recho_se
reckons13269653reckons_
recons84922993re_cons_
redbone1037973redbon_e
redbones1137593redbones
redhorse1245463redhorse
redispose1244683redispo_se
redone74820053re_don_e
redons75222183re_dons_
reexpose1744933reexpo_se
regions83613473regions_
rehouse10311773re_house
reimpose1245633reimpo_se
remorse9311713re_morse
reopens939373reopens_
reoppose1245563reoppose
repine85627813re_pin_e
repines94927383re_pines
repins84924313re_pins_
repos74725793re_po_s_
reposed103616283re_po_sed
reposer93715333re_po_ser
reposes94021263re_po_ses
repots85621003re_pots_
repousse1046053re_pousse
reprise92715043re_prise
repulse938193re_pulse
rerose63320853re_ro_se
rescore95616203resco_re
rescores105415693rescores
reshine102816943reshin_e
reshines112615443reshines
reshoe92816483resho__e
reshoes102316033reshoes_
reshows132510453reshows_
resigns83910963resigns_
resins64528773res_ins_
resods74116303res_ods_
resole64624183res_o_le
resoles73823653res_oles
resolve103910983res_olve
resonate8513513res_onate
resows93915353res_ows_
respace11310913resp_ace
respaces12311043respaces
respade1039573resp_ade
respades1139853respades
respire9411543resp_ire
respires10311903respires
respite9513033resp_ite
respites10513243respites
resplice1237253resplice
respoken14506923respoken
respondent1346053respondent
responders1345773responders
responsible1552923responsible
responsory1552253responsory
respool937643respo_ol
respooled1245593respooled
respools1036253respools
respot83117633respo__t
respotted1235953respotted
restoke116113903resto_ke
restokes125213043restokes
restore75822983resto_re
restores85222993restores
resupine1037543resupin_e
retrorse837633retrorse
rezone153814783re_zon_e
rezones163213943re_zones
spense83912433__spense
sponge939663__sponge
spouse84112513__spouse
suspense10135743suspense
testons7313563testons_
vespine1237903vespin_e
weapons12278603weapons_

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 Limit1461621217.40619735.6
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.87522690.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.