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

145 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
mangy11502125(None) 
manga85026211manga
mange84930201mange
mangey123614531mangey
mango85724331mango
manly105022951manly
many95731861man_y
mingy115520181mingy
rangy95320391rangy
tangy94519951tangy
anga56831362_anga
angry9310872_angry
any68440492_an_y
baggy125615682baggy
bandy114824192bandy
bang74837012bang_
bangs85627782bangs
banty106624002banty
cadgy125210782cadgy
cagy106321992ca_gy
candy115119822candy
canny105817692canny
canty105226802canty
dandy104416702dandy
dang65131552dang_
dangly114212272dangly
dangs75623212dangs
dingy105721262dingy
dungy104713642dungy
faggy136514372faggy
fancy134615482fancy
fang85432562fang_
fanga96119632fanga
fangs96224082fangs
fanny114816042fanny
gang66031982gang_
gangly113911592gangly
gangs76222582gangs
handy125520872handy
hang85535562hang_
hangs95726732hangs
hanky155418292hanky
jaggy175913142jaggy
jangly174310612jangly
janty156816962janty
lang56637392lang_
lanky125517482lanky
lingy96925142lingy
madly115218132madly
mag67956482ma_g_
mage75739132ma_ge
magi76329532ma_gi
mags75444532ma_gs
mainly11411492mainly
malmy124816342malmy
malty106721702malty
mamey125418832mamey
mammy115215162mammy
man57465872man__
mana65341962man_a
manage93818902manage
manas76240432manas
manat76039992manat
mane65052032man_e
maned86634102maned
manege94113202manege
manes76648962manes
mangaby1535352mangaby
mangas94122932mangas
mangel94017542mangel
manger94325012manger
manges94628952manges
mangily1339752mangily
mangle93921332mangle
mangos94319342mangos
mania75634152mania
manic94629442manic
manna75522542manna
mano66536812man_o
manor78023932manor
manos74933622manos
mans66354552man_s
manse75528232manse
manta75629912manta
manus75924932manus
margay12310602margay
marge85328332marge
marly106925612marly
marry104821692marry
marvy135014032marvy
mashy136016502mashy
massy104518962massy
matey107022662matey
maundy12506782maundy
may88757632ma__y
mazy186419702ma_zy
meanly115412042meanly
meany104620482mean_y
mincy125817412mincy
minny104518662minny
minty106323902minty
moggy125212162moggy
money104826842money
mongo810122412mongo
mony96830012mon_y
muggy125612372muggy
mungo84916052mungo
naggy106612822naggy
nancy105214922nancy
nanny84813812nanny
orangy105111232orangy
pandy115021172pandy
pang75336302pang_
panga85323542panga
pangs84628672pangs
pansy105717972pansy
panty105929302panty
raggy106116572raggy
randy95022082randy
rang56939172rang_
range64728422range
saggy105917462saggy
sagy85327082sa_gy
sandy94221132sandy
sang55441242sang_
sanga66023802sanga
sangh95517462sangh
slangy105411392slangy
tang56138692tang_
tanga64923712tanga
tangly104413932tangly
tango66921192tango
tangs65028362tangs
tansy84514942tansy
twangy13386992twangy
vang84926052vang_
vangs96319602vangs
waney115120322waney
wanly115118022wanly
wany106432362wan_y
wingy126521032wingy
yang85626082yang_
yangs95618702yangs
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.296603685.8
2DLD Change Limit538001451.47036598.6
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.81298615.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.