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

139 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
refroze195622(None) 
prefroze2264671prefroze
refrozen2063871refrozen
froze174515652__froze
prefrozen2352842prefrozen
redrove11249422redrove
reforge11259032reforge
reframe1239392reframe
refreeze2063262refreeze
refront10313262refront
reprobe112310132reprobe
reprove122911072reprove
rerose63320842re_rose
rewrote1039122rewrote
unfroze1945412unfroze
aerobe8412403ae_robe
before11410153bef_ore
croze164719453__croze
deepfroze2451373deepfroze
deforce13267243deforce
defrock1744643defrock
defrost1139553defrost
defuze19487843def_uze
enrobe86610793_enrobe
erode64520993_e_rode
erose55727273_e_rose
froe75329993__fro_e
frore86218803__frore
frozen18408443__frozen
heroize193210963he_roize
leprose938543leprose
necrose939723necrose
neurone739433neurone
prefreeze2342093prefreeze
realize162717083realize
reargue836463reargue
rearouse839363rearouse
reawoke14397443reawoke
rebore86625653re_bore
rebozo1737323re_bozo
rechose121312043rechose
recode93618713re_code
recrate92621663recrate
recross989833recross
recrown12257573recrown
redbone1037973redbone
redone74820053re_done
redrive112410563redrive
redroot8312903redroot
reevoke14386363reevoke
reface113616353ref_ace
refence12312233refence
referee101615753referee
refile95122373ref_ile
refine95225693ref_ine
refire95419473ref_ire
reflate103516263reflate
refloat10310833refloat
reflood1136363reflood
reflow12379653reflo_w
reflowed15126903reflowed
reflower14126843reflower
reflown13316213reflown
reflows13258983reflows
refold103812113ref_old
reforged13268703reforged
reforges12249333reforges
reform11312713ref_orm
reformed14249603reformed
reformer13217953reformer
reforms1239823reforms
refract121311603refract
refrain10310043refrain
reframed1437853reframed
reframes1338993reframes
refreezes2153443refreezes
refresh1335453refresh
refried113513873refried
refries104419733refries
refronted1336053refronted
refronts1137773refronts
refry114412463refr__y
refuge105312613ref_uge
refugee115310943refugee
refuse94817513ref_use
refute95515703ref_ute
reglaze1747223reglaze
regorge9257833regorge
regrade92612033regrade
regrate82618663regrate
regroom1077303regroom
regroove1243673regroove
regroup1095173regroup
regrow10309883regro_w
regrown11237363regrown
regrows11269153regrows
remorse9311713remorse
remote84222603re_mote
remove116115573re_move
repose84121413re_pose
reprice113212833reprice
reprise92715043reprise
repro75315913repro__
reprobed13228743reprobed
reprobes121910293reprobes
reproof1238783reproof
repros84216003repro_s
reproved14199473reproved
reprover13229203reprover
reproves132011473reproves
rerise64325633re_rise
reroll6412683re_roll
reroof9315003re_roof
reroute7313963re_route
rescore95616203rescore
reseize1639553reseize
reshoe92816483resho_e
reshone102414163reshone
resize154117723re_size
resole64624183re_sole
respoke134311283respoke
restoke116113903restoke
restore75822983restore
restrove1138963restrove
retore67630773re_tore
retrace91417343retrace
retro55020953retro__
retrorse837623retrorse
retros63820193retro_s
revoke135216243re_voke
revote94917453re_vote
rewoke1339521223re_woke
rewore938030163re_wore
rewove126420083re_wove
rewrite10311143rewrite
rezone153814783re_zone
safrole1037253safrole
tetrode839343tetrode
unfrozen2043753unfrozen

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271396.78019768.0
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.23224708.4
 
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.