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

84 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
reechiest144601(None) 
beechiest1645001beechiest
beachiest1638442beachiest
leachiest1437242leachiest
peachiest1638522peachiest
preachiest1746982preachiest
reechier1336672reechie_r
reechoes1338412reechoes_
reediest92815422ree_diest
reefiest112811482ree_fiest
reekiest122711312ree_kiest
screechiest1842742screechiest
techiest1359832_techiest
tetchiest1445792tetchiest
achiest12315183__achiest
beeches143413883beech_es_
beechier1535633beechie_r
beechmast1852923beechmast
beefiest13269013bee_fiest
beeriest104013403bee_riest
bitchiest1636083bitchiest
botchiest1636153botchiest
branchiest1746713branchiest
breathiest1545993breathiest
breeches15258673breech_es_
breeziest2035063bree_ziest
bunchiest1635663bunchiest
catchiest1638313catchiest
chichiest1936343chichiest
creepiest1337063cree_piest
crunchiest1764793crunchiest
deediest102912253dee_diest
eeliest73516473_ee_liest
eeriest73620673_ee_riest
fleeciest1434873fleec_iest
fleshiest1576223fleshiest
geekiest13257863gee_kiest
greediest1147553gree_diest
greeniest1039033gree_niest
grouchiest1644123grouchiest
heathiest1549383heathiest
itchiest1336523_itchiest
kvetchiest2241953kvetchiest
leeches123911933leech_es_
leeriest83112883lee_riest
meshiest132911033_meshiest
neediest92611303nee_diest
patchiest1638353patchiest
peckiest162711393_peckiest
pitchiest1646703pitchiest
poachiest1636883poachiest
pouchiest1636843pouchiest
punchiest1636453punchiest
raciest92820013r_ac_iest
raunchiest1543933raunchiest
reaches123423203reach_es_
readiest93719043r_eadiest
recentest11410283recentest
recheat12415933r_ech_eat
reechoed1436083reechoe_d
reenlist8410363reenli_st
reexhibit2151743reexhibit
retches123318513retch_es_
rheumiest1442863rheumiest
richest122813683r_ich_est
rockiest142912223r_ockiest
rushiest113312923r_ushiest
seediest92714053see_diest
seemliest1145613seemliest
seepiest102412623see_piest
sketchiest1943163sketchiest
stenchiest1545083stenchiest
stretchiest1644193stretchiest
techies12513603_techies_
teeniest82112413tee_niest
teensiest945823teensiest
torchiest1438033torchiest
touchiest1437083touchiest
treacliest1245383treacliest
weediest122311133wee_diest
weeniest112411213wee_niest
weensiest1244743weensiest
weepiest13219473wee_piest
witchiest1736313witchiest

Search took 10 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.190940478.9
2DLD Change Limit148641849.03016460.8
3Display Results84840.0461826.1
 (SQL Overall)178691849.26619284.6
 
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.