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
mangy11502123(None) 
manga85026191manga
mange84930181mange
mangey123614521mangey
mango85724311mango
manly105022941manly
many95731841man_y
mingy115520181mingy
rangy95320381rangy
tangy94519931tangy
anga56831352_anga
angry9310862_angry
any68440482_an_y
baggy125615682baggy
bandy114824182bandy
bang74836992bang_
bangs85627772bangs
banty106624002banty
cadgy125210782cadgy
cagy106321992ca_gy
candy115119822candy
canny105817692canny
canty105226802canty
dandy104416702dandy
dang65131532dang_
dangly114212262dangly
dangs75623202dangs
dingy105721262dingy
dungy104713642dungy
faggy136514372faggy
fancy134615482fancy
fang85432542fang_
fanga96119622fanga
fangs96224072fangs
fanny114816042fanny
gang66031962gang_
gangly113911582gangly
gangs76222572gangs
handy125520872handy
hang85535542hang_
hangs95726722hangs
hanky155418292hanky
jaggy175913142jaggy
jangly174310602jangly
janty156816962janty
lang56637372lang_
lanky125517482lanky
lingy96925142lingy
madly115218132madly
mag67956472ma_g_
mage75739122ma_ge
magi76329522ma_gi
mags75444522ma_gs
mainly11411492mainly
malmy124816342malmy
malty106721702malty
mamey125418832mamey
mammy115215162mammy
man57465852man__
mana65341942man_a
manage93818902manage
manas76240422manas
manat76039982manat
mane65052012man_e
maned86634092maned
manege94113202manege
manes76648952manes
mangaby1535352mangaby
mangas94122922mangas
mangel94017532mangel
manger94325002manger
manges94628942manges
mangily1339752mangily
mangle93921322mangle
mangos94319332mangos
mania75634142mania
manic94629432manic
manna75522532manna
mano66536792man_o
manor78023922manor
manos74933612manos
mans66354532man_s
manse75528222manse
manta75629902manta
manus75924922manus
margay12310592margay
marge85328332marge
marly106925612marly
marry104821692marry
marvy135014032marvy
mashy136016502mashy
massy104518962massy
matey107022662matey
maundy12506782maundy
may88757622ma__y
mazy186419692ma_zy
meanly115412042meanly
meany104620472mean_y
mincy125817412mincy
minny104518662minny
minty106323902minty
moggy125212162moggy
money104826842money
mongo810122412mongo
mony96830002mon_y
muggy125612372muggy
mungo84916052mungo
naggy106612822naggy
nancy105214922nancy
nanny84813812nanny
orangy105111232orangy
pandy115021172pandy
pang75336282pang_
panga85323532panga
pangs84628662pangs
pansy105717972pansy
panty105929302panty
raggy106116572raggy
randy95022082randy
rang56939152rang_
range64728412range
saggy105917462saggy
sagy85327082sa_gy
sandy94221132sandy
sang55441222sang_
sanga66023792sanga
sangh95517452sangh
slangy105411392slangy
tang56138662tang_
tanga64923682tanga
tangly104413912tangly
tango66921172tango
tangs65028342tangs
tansy84514932tansy
twangy13386982twangy
vang84926032vang_
vangs96319582vangs
waney115120322waney
wanly115118022wanly
wany106432352wan_y
wingy126521032wingy
yang85626062yang_
yangs95618692yangs
zany167316982zan_y
zingy186516132zingy

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.0931921408.6
2DLD Change Limit538001451.92327977.1
3Display Results1451450.0463152.2
 (SQL Overall)1786911452.06286659.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.