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

159 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
reforest113996(None) 
deforest1238791deforest
reforests1245531reforests
afforest1446342afforest
deforests1344372deforests
forest94926742__forest
reafforest1652832reafforest
rearrest8311602rearrest
rebores95319162rebores_
referent112813422referent
refires104820312refires_
reforested1445382reforested
reforges12249332reforges_
reformat1357652reformat
reformist1445912reformist
reforms1239822reforms_
refresh1335452ref_resh
remotest103310722remotest
afforests1543733afforests
before11410153before__
befret11315963bef_re_t
befrets1237613bef_rets
dearest83618673de_arest
deferent122712873deferent
deffest14308803def_fest
deforces14248403deforces_
deforested1543843deforested
deforms1337803deforms_
defrost1139553def_rost
deftest112611713def_test
demurest1137453demurest
fores85847103__fores_
forests104114953__forests
headrest122910203headrest
heftiest1439183heftiest
leftest10269463lef_test
merest84725113me__rest
nearest73415843ne_arest
poorest9312773_poorest
prefires134313283prefires_
preformat1646363preformat
preforms1537403preforms_
rarest65725483r__arest
readiest93719043readiest
reafforests1751433reafforests
realest73322433re_alest
rearrests945313rearrests
rebore86625653rebore__
rebored105015883rebore_d
recodes102918633recodes_
recordist1246923recordist
records105213923records_
recorks134813023recorks_
redbreast1243623redbreast
reddest9311953re_ddest
redigest1039733redigest
redirect11147993redirect
redoes74623773redo_es_
redolent9411883redolent
redoxes15310883redoxes_
redress82511873re_dress
reediest92815423reediest
reefiest112811483reefiest
reekiest122711313reekiest
reerect92915883re_erect
reest54938093re___est
refaces123216743refaces_
refect114319333ref__ect
refelt94521423ref__elt
referee101615753refere_e
refereed12149693refereed
referees111310413referees
referents12259643referents
refers93921083refer_s_
refiles104122423refiles_
refines105426343refines_
refire95419473refire__
refired115116993refire_d
refixes174813173refixes_
reflect123913713ref_lect
reflet94024233ref_le_t
reflets103513153ref_lets
reflies104418533reflies_
refluent1147433refluent
refocus1236973refocus_
refolds11298953refolds_
reforesting1546193reforesting
reforge11259033refor_ge
reforged13268703reforged
reform11312713refor__m
reformate1446953reformate
reformats1445713reformats
reformed14249603reformed
reformer13217953reformer
reformers14246403reformers
reformism1643703reformism
reformists1544123reformists
refought1564233refought
refract121311603ref_ract
refries104419733refries_
refront10313263ref_ront
refronts1137773refronts
refuges115413373refuges_
refuses104918553refuses_
refutes104515733refutes_
regorges10238413regorges_
regreet83015953re_greet
regress82711453re_gress
regret73723533re_gre_t
regrets83212923re_grets
rehires105016113rehires_
reinvest1138203reinvest
remoras9314073remoras_
remorse9311713remor_se
remorses10311993remorses
remotes94521613remotes_
removes124514713removes_
renest64529713re__nest
reorient8613473re_orient
report85326023repor__t
reports94916213reports_
reposes94021263reposes_
repress92712683re_press
request16311023re_quest
rerent63832453re__rent
rescores105415693rescores_
resojet14312823resoje_t
resojets1535343resojets
resoles73823653resoles_
resorbs95010523resorbs_
resort65728623resor__t
resorts74817193resorts_
restores85222993restores_
restress82511773restress
retest64028453re__test
retires74726213retires_
retore67630773retore__
retort66831153retor__t
retorts76016513retorts_
retreat7317533re_treat
reverent112615093reverent
reveres103621343reveres_
revest94623603re__vest
revokes144212503revokes_
revotes104716393revotes_
rewires104717113rewires_
rewords115413983rewords_
rewore938030163rewore__
reworks145113603reworks_
rezones163213943rezones_
rifest93114583rif__est
rigorist949123rigorist
searest73322023se_arest
securest1058583securest
senores73218113senores_
serest64831613se__rest
severest11310323severest
sorest65028003__sorest
tenorist8413023tenorist

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 Filter1786911461620.516346300.4
2DLD Change Limit1461621598.39017421.0
3Display Results1591590.0632523.8
 (SQL Overall)1786911598.96919923.2
 
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.