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

71 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
reforests124553(None) 
deforests1344371deforests
reforest1139961reforest_
afforests1543732afforests
deforest1238792deforest_
forests104114952__forests
reafforests1751432reafforests
rearrests945312rearrests
referents12259642referents
reforested1445382reforested
reformats1445712reformats
reformists1544122reformists
afforest1446343afforest_
befrets1237613bef_re_ts
deferents13269393deferents
deforested1543843deforested
defrosts1244833def_rosts
forest94926743__forest_
headrests13245023headrests
preformats1744413preformats
reafforest1652833reafforest_
rearrest8311603rearrest_
rebores95319163rebore__s
recordists1344403recordists
redbreasts1342043redbreasts
redigests1154683redigests
redirects12125103redirects
redress82511873re_dres_s
reerects10319923re_erects
reests64618893re___ests
refects124012743ref__ects
referees111310413refere_es
referent112813423referent_
refires104820313refire__s
reflects13288873ref_lects
reflets103513153ref_le_ts
refocuses14135953refocuses
reforesting1546193reforesting
reforges12249333refor_ges
reformat1357653reformat_
reformate1446953reformate
reformates1546263reformates
reformers14246403reformers
reformisms1743043reformisms
reformist1445913reformist_
reforms1239823refor__ms
refracts13137383ref_racts
refresh1335453ref_res_h
refreshes1595953ref_reshes
refronts1137773ref_ronts
regreets9287853re_greets
regress82711453re_gres_s
regrets83212923re_gre_ts
reinvests1244223reinvests
remorses10311993remor_ses
remotest103310723remotest_
renests74014213re__nests
reorients997363re_orients
reports94916213repor__ts
repress92712683re_pres_s
requests1735743re_quests
rerents73319423re__rents
resojets1535343resoje_ts
resorts74817193resor__ts
restress82511773restres_s
retests73813853re__tests
retorts76016513retor__ts
retreats8311413re_treats
revests104413733re__vests
rigorists1045673rigorists
tenorists948193tenorists

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 Filter1786911486410.423422437.4
2DLD Change Limit148641717.29620372.9
3Display Results71710.0302366.7
 (SQL Overall)178691717.74923059.9
 
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.