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 “wanigan” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
wanigan113521(None) 
wangan10311221wan_gan
wanigans1244741wanigans
wannigan1242691wannigan
banian8315382bani_an
wangans1149502wan_gans
wangun1037102wan_gun
wanion93213062wani_on
wannigans1342392wannigans
wigan95114392w__igan
align65016503_alig_n
amiga85514813_amiga_
amigas95912173_amigas
anga56831353_an_ga_
angas65827983_an_gas
angina7413133_angina
anilin6417793_anilin
anima74620073_anima_
animal85016253_animal
animas84418723_animas
anion55028813_ani_on
antigang1067403_antigang
antigay1148223_antigay
antigen8311123_antigen
antigun847963_antigun
antiman9313883_antiman
anuran64313243_anuran
apian75018333_api_an
avian84616053_avi_an
banians9312033bani_ans
banyan1139483ban_yan
benign938313benig_n
brannigan1242313brannigan
caiman103615663ca_iman
cancan10314103can_can
canikin13189753canikin
cardigan1245613cardigan
eonian6311833eoni_an
fanega1055783fanega_
fanegas1145713fanegas
fanga96119623fan_ga_
fangas105017193fan_gas
fanion94514323fani_on
habitan1236903habitan
handgun1244623handgun
hangar104114513han_gar
hangman1337813hangman
haniwa1236743haniwa_
hanuman1237133hanuman
harijan1735783harijan
kalian10312163kali_an
kanban1238623kan_ban
lagan66520343la__gan
landman1038923landman
lanital7310913lanital
larrigan944213larrigan
ligan67920283__ligan
longan75612363lon_gan
lungan74710213lun_gan
magian9312833magi_an
malign939853malig_n
manga85026203man_ga_
mangas94122923man_gas
mania75634153mani_a_
maniac103917973mani_ac
manias84029033mani_as
manikin132110243manikin
manila84518303manila_
manilas93915873manilas
mannan85413623man_nan
minivan1245713minivan
origan7310693_origan
pagan86121163pa__gan
paisan84417073pa_isan
panga85323533pan_ga_
pangas99921103pan_gas
pangen94115913pan_gen
parian83223963pari_an
radian74117273radi_an
randan7315253ran_dan
saiga64717933sa_iga_
saigas74114293sa_igas
sandman10310173sandman
sanga66023793san_ga_
sangar73617683san_gar
sangas75222653san_gas
swanpan1243693swan_pan
taiga64115663ta_iga_
taigas73712563ta_igas
taipan82410663ta_ipan
tanga64923693tan_ga_
taximan1635783taximan
vanman1139793van_man
waggon1136393wa_ggon
wagon94312953wa__gon
wain75840203wa_i__n
wangle103817503wan_gle
wanguns1135023wan_guns
wanier93920683wani_er
waniest103819113waniest
waning103623803wani_ng
wanions104011373wanions
wantage11119623wantage
wanton94413813wan_ton
warison1037083warison
warrigal1244313warrigal
wigans104511703w__igans
wingman1336383wingman
witan83816503w__itan
xanthan1736013xanthan
yatagan1144133yatagan

Search took 10 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271119.50014108.1
3Display Results1111110.0303700.0
 (SQL Overall)1786911119.68618448.4
 
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.