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

197 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
ruins5582203(None) 
bruins86014951bruins
quins144819851quins
rains55140231rains
reins56234561reins
rins46153191r_ins
ruin47430511ruin_
ruing67221051ruing
runs46438071ru_ns
rutins63818391rutins
ains46158882_ains
amins75534322amins
auxins13129812auxins
ayins85321612ayins
bins66548252_bins
brains85125472brains
brins75533972brins
brucins1158002brucins
bruin75818332bruin_
bruits85714452bruits
bunns74718292bunns
buns66243722bu_ns
burins84221892burins
burns74926772burns
cains75334302cains
chins105631462chins
coins75834552coins
cuifs104814692cuifs
cuing85420192cuing
cumins103314932cumins
curns74924272curns
cutins83919982cutins
dins56652042_dins
djins1368452djins
drains73719402drains
druids8368092druids
duits65021882duits
duns55140432du_ns
durns64819862durns
fins75849092_fins
foins85523382foins
fruits94512492fruits
funs75235732fu_ns
gains65729512gains
gins55543952_gins
grains74223092grains
grins65427222grins
groins73917202groins
guans64419442guans
guids75516152guids
guns55533482gu_ns
hins76447992_hins
huns76136932hu_ns
ins35945602__ins
jins115635012_jins
joins125818412joins
kains96125642kains
kins85747902_kins
lins47059052_lins
loins56728422loins
lupins84514462lupins
mains75635112mains
mucins102712512mucins
munis75022002munis
muns65535922mu_ns
muons75816172muons
nuns45228232nu_ns
orcins83313432orcins
orpins83614162orpins
pains75138282pains
peins76128062peins
pins65558452_pins
puns66641482pu_ns
purins83722652purins
pyins105815862pyins
quids154917462quids
quin135823922quin_
quinsy18386352quinsy
quint144529902quint
quints154316562quints
quips164713372quips
quits144122352quits
quoins154110582quoins
raias54631122raias
raids65827512raids
rails55937402rails
rain46251732rain_
rainy85921082rainy
rais45252622rai_s
ranis55235832ranis
ravins94622562ravins
rawins95617622rawins
reifs84819092reifs
reigns74811752reigns
rein46040892rein_
reink95518092reink
reinks105012152reinks
reis45343232rei_s
renins64526452renins
repins84924312repins
requins16310202requins
resins64528772resins
rewins95020822rewins
rhino84614322rhino
rhinos94411122rhinos
rias45540592r_ias
ribs65833022r_ibs
ricins83618702ricins
rids56539542r_ids
rifs74929002r_ifs
rigs55137592r_igs
rims65936302r_ims
rin36663182r_in_
rind56535602r_ind
rinds64826142r_inds
ring56541152r_ing
rings65029172r_ings
rink87736992r_ink
rinks94827102r_inks
rinse54820972r_inse
rips66237432r_ips
roans54926442roans
robins83617452robins
roils54826792roils
rosins64521862rosins
rouens64814442rouens
ruana5312422ruana
ruanas6311262ruanas
rubes74928412rubes
rubies84420342rubies
rubs66133492ru_bs
rubus76415062rubus
rucks114422052rucks
rudds74811702rudds
ruers515019412ruers
rues46044482ru_es
ruffs114516742ruffs
rugs56033682ru_gs
ruined74813322ruined
ruiner64013642ruiner
ruiners74213022ruiners
ruinous739762ruinous
rules55234252rules
ruling73219552ruling
rulings83310382rulings
rumens83611812rumens
rumina83412482rumina
rumps95922292rumps
rums64833472ru_ms
run36244982ru_n_
rune45236292ru_ne
runes55530222runes
rung56429972ru_ng
rungs611819402rungs
runic73615772runic
runny84613482runny
runt46647982ru_nt
runts55927632runts
ruses56136582ruses
rusine63916592rusine
rusks95816192rusks
rusts55026992rusts
ruths85714642ruths
rutin55421342rutin_
ruts44541492ru_ts
sains55639972sains
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
suing65026362suing
suint55638182suint
suints64617782suints
suits55028052suits
sunns55017352sunns
suns45841902su_ns
tains54936322tains
thins85826332thins
tins45251302_tins
trains64725342trains
truing73913932truing
tuis44829642tui_s
tuns45138662tu_ns
turns55623232turns
twins85118982twins
uns35936752_u_ns
urine55026592urine
urines64724122urines
urns46323892_urns
veins84620492veins
wains86930872wains
whins114922332whins
wins75949172_wins
yins75335122_yins
yuans84613322yuans
zeins144715392zeins
zins135735002_zins

Search took 3 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 Filter178691538000.623286823.4
2DLD Change Limit538001972.29623432.1
3Display Results1971970.0464282.6
 (SQL Overall)1786911972.96560266.8
 
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.