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

146 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
rangy9532038(None) 
mangy115021241mangy
orangy105111231orangy
raggy106116571raggy
randy95022081randy
rang56939161rang_
range64728411range
tangy94519931tangy
anga56831352_anga
angry9310862_angry
any68440492_an_y
baggy125615682baggy
bandy114824182bandy
bang74837002bang_
bangs85627772bangs
banty106624002banty
braggy13337172braggy
brandy124712062brandy
branny115111832branny
cadgy125210782cadgy
cagy106321992ca_gy
candy115119822candy
canny105817692canny
canty105226802canty
craggy13396602craggy
cranky153910632cranky
cranny114210272cranny
dandy104416702dandy
dang65131542dang_
dangly114212262dangly
dangs75623202dangs
dingy105721262dingy
draggy12346822draggy
dungy104713642dungy
faggy136514372faggy
fancy134615482fancy
fang85432552fang_
fanga96119622fanga
fangs96224072fangs
fanny114816042fanny
fringy13309262fringy
gang66031972gang_
gangly113911582gangly
gangs76222572gangs
grange83716202grange
granny104311162granny
grungy11345972grungy
handy125520872handy
hang85535552hang_
hangs95726722hangs
hanky155418292hanky
jaggy175913142jaggy
jangly174310602jangly
janty156816962janty
lang56637382lang_
lanky125517482lanky
lingy96925142lingy
manga85026202manga
mange84930192mange
mangey123614522mangey
mango85724322mango
manly105022952manly
many95731862man_y
mingy115520182mingy
naggy106612822naggy
nancy105214922nancy
nanny84813812nanny
orang65119942orang_
orange74016322orange
orangey11388832orangey
orangs74116032orangs
pandy115021172pandy
pang75336292pang_
panga85323532panga
pangs84628662pangs
pansy105717972pansy
panty105929302panty
prang84820322prang_
prangs94816232prangs
racy95825682ra_cy
rag45761322ra_g_
raga55930812ra_ga
rage55742352ra_ge
ragg65622692ra_gg
raggs75216472raggs
ragi56032282ra_gi
rags55448372ra_gs
rainy85921082rainy
rally84725902rally
rammy124312492rammy
ran38266622ran__
rance75028512rance
ranch105019792ranch
rand55839572ran_d
rands65930452rands
ranee55438102ranee
ranged84824312ranged
ranger73925522ranger
ranges73826922ranges
rani46640112ran_i
ranid66429332ranid
ranis55235832ranis
rank85135532ran_k
rankly133910452rankly
ranks95225732ranks
rant45864682ran_t
rants55935342rants
raspy106511702raspy
ratty84819592ratty
rawly115115832rawly
ray66361992ra__y
ridgy104110642ridgy
rindy95717392rindy
ring56541152ring_
rings65029172rings
rung56429982rung_
rungs611819402rungs
runny84613482runny
runty86119042runty
saggy105917462saggy
sagy85327082sa_gy
sandy94221132sandy
sang55441232sang_
sanga66023792sanga
sangh95517452sangh
slangy105411392slangy
tang56138672tang_
tanga64923692tanga
tangly104413912tangly
tango66921172tango
tangs65028342tangs
tansy84514932tansy
tranny94210862tranny
twangy13386982twangy
vang84926042vang_
vangs96319582vangs
waney115120322waney
wanly115118022wanly
wany106432362wan_y
wingy126521032wingy
wrang94716112wrang_
wrangs104611912wrangs
yang85626072yang_
yangs95618692yangs
zany167316992zan_y
zingy186516132zingy

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 Filter178691538000.310576422.6
2DLD Change Limit538001461.56334421.0
3Display Results1461460.0463173.9
 (SQL Overall)1786911461.91993116.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.