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
rangy9532039(None) 
mangy115021251mangy
orangy105111231orangy
raggy106116571raggy
randy95022081randy
rang56939171rang_
range64728421range
tangy94519951tangy
anga56831362_anga
angry9310872_angry
any68440492_an_y
baggy125615682baggy
bandy114824192bandy
bang74837012bang_
bangs85627782bangs
banty106624002banty
braggy13337172braggy
brandy124712062brandy
branny115111832branny
cadgy125210782cadgy
cagy106321992ca_gy
candy115119822candy
canny105817692canny
canty105226802canty
craggy13396602craggy
cranky153910632cranky
cranny114210272cranny
dandy104416702dandy
dang65131552dang_
dangly114212272dangly
dangs75623212dangs
dingy105721262dingy
draggy12346822draggy
dungy104713642dungy
faggy136514372faggy
fancy134615482fancy
fang85432562fang_
fanga96119632fanga
fangs96224082fangs
fanny114816042fanny
fringy13309262fringy
gang66031982gang_
gangly113911592gangly
gangs76222582gangs
grange83716202grange
granny104311162granny
grungy11345972grungy
handy125520872handy
hang85535562hang_
hangs95726732hangs
hanky155418292hanky
jaggy175913142jaggy
jangly174310612jangly
janty156816962janty
lang56637392lang_
lanky125517482lanky
lingy96925142lingy
manga85026212manga
mange84930202mange
mangey123614532mangey
mango85724332mango
manly105022952manly
many95731862man_y
mingy115520182mingy
naggy106612822naggy
nancy105214922nancy
nanny84813812nanny
orang65119942orang_
orange74016322orange
orangey11388832orangey
orangs74116032orangs
pandy115021172pandy
pang75336302pang_
panga85323542panga
pangs84628672pangs
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
ranged84824322ranged
ranger73925532ranger
ranges73826932ranges
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
sang55441242sang_
sanga66023802sanga
sangh95517462sangh
slangy105411392slangy
tang56138692tang_
tanga64923712tanga
tangly104413932tangly
tango66921192tango
tangs65028362tangs
tansy84514942tansy
tranny94210862tranny
twangy13386992twangy
vang84926052vang_
vangs96319592vangs
waney115120322waney
wanly115118022wanly
wany106432362wan_y
wingy126521032wingy
wrang94716112wrang_
wrangs104611912wrangs
yang85626082yang_
yangs95618702yangs
zany167316992zan_y
zingy186516132zingy

Search took 5 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.843211970.3
2DLD Change Limit538001463.62614837.3
3Display Results1461460.0463173.9
 (SQL Overall)1786911464.51539577.2
 
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.