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

54 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
refrozen206387(None) 
prefrozen2352841prefrozen
refroze1956221refroze_
frozen18408442__frozen
prefroze2264672prefroze_
unfrozen2043752unfrozen
deepfrozen255963deepfrozen
froze174515653__froze_
kerogen1236093ke_rogen
nonfrozen2152983nonfrozen
reawoken15454843reawoken
rechosen13127043rechosen
recrown12257573recro_wn
redriven12226153redriven
redrove11249423redrove_
refallen1136213refallen
refasten1136103refasten
reflowed15126913reflowed
reflower14126853reflower
reflown13316213reflo_wn
reforge11259033reforge_
reforged13268703reforged
reforges12249333reforges
reformed14249603reformed
reformer13217953reformer
refrain10310043refr_ain
reframe1239393reframe_
reframed1437853reframed
reframes1338993reframes
refreeze2063263refreeze
refreezes2153443refreezes
refreshen1585163refreshen
refried113513883refr_ied
refries104419733refr_ies
refront10313263refro_nt
refronted1336063refronted
refronts1137773refronts
regreen8309043regr_een
regrown11237363regro_wn
reopen8311573re__open
reprobe112310133reprobe_
reprobed13228753reprobed
reprobes121910293reprobes
reprove122911073reprove_
reproved14199483reproved
reprover13229203reprover
reproves132011473reproves
rerisen73613643re_risen
rerose63320853re_rose_
respoken14506923respoken
rewoken145112293re_woken
rewoven13557933re_woven
rewrote1039123rewrote_
unfroze1945413unfroze_

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.420425454.8
2DLD Change Limit146162546.50022486.5
3Display Results54540.0163375.0
 (SQL Overall)178691546.93625762.8
 
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.