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 “rynd” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
rynd8641410(None) 
rand55839571rand
rend56136571rend
rind56535601rind
rynds9569971rynds
wynd116114461wynd
and47244172_and
band76740912band
bend76435262bend
bind76234512bind
bond75334362bond
brand85124492brand
bund75530662bund
dryad10477582dryad
dyad96415452dyad
dyed96720762dyed
dyne85320932dyne
end46834352_end
eyed86623232eyed
eyne76322462eyne
fend84832972fend
find87532602find
fond86330952fond
frond95316342frond
fund85624982fund
grand75122692grand
grind75917562grind
hand86833712hand
hind85529752hind
kind96128562kind
land56337312land
lend56233672lend
lynx1437422lynx
mend75334032mend
mind75434382mind
myna95815302myna
pend75934532pend
pond75530492pond
rad47662002r_ad
raid55243072raid
ran38266622ran_
rands65930452rands
randy95022082randy
rang56939162rang
rani46640112rani
ranid66429332ranid
rank85135532rank
rant45864682rant
rayed95127502rayed
read55942532read
red46755802r_ed
redd66323172redd
reed55549622reed
rends65129952rends
rent46661242rent
rid46754632r_id
rin36663182rin_
rinds64826142rinds
rindy95717392rindy
ring56541152ring
rink87736992rink
rins46153192rins
road56332112road
rod47953892r_od
rondo65218372rondo
rood56733002rood
round64318432round
rudd65917472rudd
rued55729792rued
run36244992run_
rune45236302rune
rung56429982rung
runs46438082runs
runt46647992runt
rya67622012ry_a
ryas77224612ryas
rye66032542ry_e
ryes75529352ryes
ryke115616402ryke
ryked13669512ryked
ryot75528562ryot
sand55338472sand
send55237292send
syn67024122syn_
sync95415102sync
syne75725762syne
synod9610282synod
tend56433772tend
trend64817452trend
tyne76325052tyne
tyned95915012tyned
vend86626422vend
wand85833882wand
wend85330452wend
wind85533852wind
wyn95921442wyn_
wynds126310372wynds
wynn105811292wynn
wyns105717032wyns
yid76640832_yid
yod77545502_yod
yond86122312yond

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721020.87634100.5
3Display Results1021020.0166375.0
 (SQL Overall)1786911021.172152466.7
 
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.