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

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

78 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
redhorse124546(None) 
redhorses1345651redhorses
rechoose13137342rechoose
rechose121312042recho_se
rehouse10311772re_house
remorse9311712re_morse
retrorse837622retrorse
seahorse1145592seahorse
ahorse9311513__ahorse
beadhouse1544423beadhouse
bedehouse1544073bedehouse
bedsore1057803bedsor_e
bedsores1157633bedsores
endorse879203_endorse
ephors11311403_ephors_
henhouse1445573henhouse
horse86132653___horse
indorse8108193ind_orse
madhouse1445503madhouse
prechoose16105633prechoose
prechose15129773precho_se
premorse1237553pre_morse
racehorse1443763racehorse
rearouse839363rearouse
rebore86625653re_bor_e
rebores95319163re_bores
recharge1476613recharge
rechooses14107613rechooses
rechosen13127033recho_sen
recourse1038383recourse
rectors93520523rectors_
redbone1037973redbo_ne
redbones1137593redbones
redders93615343redders_
redears82814453redears_
redivorce1542703redivorce
redoes74623773red_oes_
redone74820053red_o_ne
redons75222183red_ons_
redos65126763red_o_s_
redoxes15310883red_oxes
redrove11249423redro_ve
redtops1037373redtops_
redware1139363redwar_e
redwares1239053redwares
reforge11259033re_forge
regorge9257833re_gorge
rehearse11296653rehearse
rehire95415863re_hir_e
rehires105016113re_hires
rehoused1239613re_housed
rehouses11312113re_houses
remorses10311993re_morses
rephrase1346733rephrase
repose84121413re_po_se
rerose63320843re_ro_se
rescore95616203rescor_e
rescores105415693rescores
reshoe92816483resho__e
reshoes102316033reshoes_
reshone102414163resho_ne
reshows132510453reshows_
response1037753response
restore75822983restor_e
restores85222993restores
retore67630773re_tor_e
reverse103913743re_verse
rewore938030163re_wor_e
roadhouse1344673roadhouse
sawhorse1443523sawhorse
seahorses1246163seahorses
senhores112810993senhores
senhors103512133senhors_
studhorse1342033studhorse
teahouse1146073teahouse
treehouse1245033treehouse
unhorse1038583_unhorse
warhorse1445343warhorse

Search took 7 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.440406115.9
2DLD Change Limit146162786.43622710.1
3Display Results78780.0302600.0
 (SQL Overall)178691786.90625874.7
 
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.