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 “rechooses” 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
rechooses1410761(None) 
prechooses17116401prechooses
rechoose13137341rechoose_
chooses125717412__chooses
prechoose16105632prechoose_
rechose121312042rech_ose_
rechosen13127032rech_osen
recrosses1138372recrosses
redhorses1345652redhorses
rehouses11312112re_houses
behooves1653793be_hooves
chaoses124715113__chaoses
choose115116143__choose_
chooser124412963__chooser
choosers134810863__choosers
choosey15459233__choosey
choses115825123__ch_oses
chouses125117813__chouses
chowses155611283__chowses
deckhouses2083493deckhouses
echoes114715523_ech_o_es
echoisms1546143_echoisms
echoless1345603_echoless
ethnoses1146063_ethnoses
ethoses10311753_eth_oses
henhouses1546173henhouses
icehouses1445003icehouses
mischooses1744633mischooses
necroses10310563nec_roses
nephroses1446303nephroses
prechose15129773prech_ose_
prechosen16116243prech_osen
preciouses1446883preciouses
racehorses1543923racehorses
rachises131412413rach_ises
rearouses9310203rearouses
recesses10312323rec_esses
rechanges1568183rechanges
recharges1586953recharges
rechoosing1645373rechoosing
reclothes1445643reclothes
recluses105111733rec_luses
recodes102918633rec__odes
recomposes1646063recomposes
recooked15268243rec_ooked
recooks134711233rec_oo_ks
recopies12313723rec_opies
recourses1137733recourses
recross989833rec_ros_s
recrossed1246513recrossed
rectories11314643rectories
recuses94619463rec__uses
redhorse1245463redhorse_
reechoes1338413reech_o_es
reexposes1844753reexposes
reglosses1045343reglosses
regrooves1343863regrooves
rehouse10311773re_house_
rehoused1239613re_housed
reimposes1345473reimposes
remorses10311993re_morses
reopposes1345823reopposes
rephrases1447413rephrases
reposes94021263re__poses
reredoses1045773reredoses
reschooled1643023reschooled
reschools1444083reschoo_ls
reshoes102316033resh_o_es
reshoots11228413reshoo_ts
responses1147443responses
rockroses1545563rockroses
rooses65526233r___ooses
schmooses16275623_schmooses
seahorses1246163seahorses
secaloses1146903secaloses
teahouses1246513teahouses
treehouses1345193treehouses
trichoses14107963trich_oses

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641788.15618224.7
3Display Results78780.0302600.0
 (SQL Overall)178691788.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.