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

285 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
nizams173541(None) 
nizam16310251nizam_
dirams94413702dirams
imams91511112_imams
izars145112932_izars
nicads938332nicads
nims66226882ni__ms
nipas77116672nipa_s
sizars154812622sizars
zirams17438642zirams
aims67738183ai__ms
animals94111703animals
animas84418723anima_s
azans146516883_azans
baizas173810823baiza_s
bams87044453__bams
bazars174613113bazars
beams95328173_beams
bias64738163bi_a_s
bigamy1436343bigamy
bimahs13508303bimahs
bimas95521743bima_s
bizes165923663biz_es
bizzes163910843bizzes
blams95023853_blams
breams104815043breams
cams87047283__cams
chams126028503_chams
cigars9910723cigars
clams95127673_clams
crams96229153_crams
creams104715253creams
czars164812913_czars
dams77444373__dams
dials64925343di_als
digamy1335893digamy
dims75435023di__ms
dinars75417563dinars
diram84419473diram_
dirhams13376313dirhams
disarms1039043disarms
ditas65923673dita_s
divans104612393divans
divas95418583diva_s
diwans105110373diwans
dizens164911393dizens
drams86025833_drams
dreams94513983dreams
dunams937833dunams
engrams1038073engrams
enigmas1045173enigmas
enzyms2063433enzyms
exams14199083_exams
fiars86720833fi_ars
fiats85324483fi_ats
films105617963fi_lms
finals94316163finals
firms105217423fi_rms
fizzes174512553fizzes
flams105125013_flams
fleams115011943fleams
foams105017953_foams
forams115115913forams
gams76648883__gams
gazars164811553gazars
gigas75415583giga_s
gizmo1756013giz_mo
gizmos1844133gizmos
glams85822933_glams
gleams94812253gleams
gloams95210663gloams
grams85327313_grams
hams96446133__hams
hazans183411653hazans
hijabs1833083hijabs
hims95230973hi__ms
iamb86623733_i_amb
iambs95815063_i_ambs
ihrams1137173ihrams
ikats95311153_ikats
imam81718333_imam_
imaums10106303_imaums
inarms8410093inarms
infamy1435653infamy
inlays9389873inlays
inseams9307903inseams
invars9310003invars
isms66213473_i_sms
items7499613_items
izar136616013_iza_r
jams135231073__jams
jicama1734883jicama
jicamas1845053jicamas
jihads1734483jihads
jimjams1742073jimjams
jisms14458003ji_sms
jorams154810533jorams
kalams12310603kalams
kilims1277903kilims
kinas95626913kina_s
kivas124614733kiva_s
lams66552263__lams
lazars153812393lazars
liars54723163li_ars
lidars7310783lidars
ligans76817733ligans
lilacs837483lilacs
limans84816303limans
limas75627633lima_s
linacs8310813linacs
lingams104510193lingams
linums838283linums
liras56021983lira_s
litas54923773lita_s
lizard16369233lizard
lizards17427613lizards
loams75619863_loams
madams11310943madams
miasm91211093mi_asm
miasms1097383miasms
micas96823053mica_s
minas75434113mina_s
minicams14126863minicams
minims104514813minims
mirzas1738183mirza_s
misaims11310113misaims
mizens174610253mizens
naans55815253n_aans
nabs66236193n__abs
nadas66320813nada_s
nags55436023n__ags
naiads739013naiads
nairas6312783naira_s
nalas55528363nala_s
nam55953393n__am_
name65637413n__ame
names74833363n__ames
nanas55928633nana_s
nans46139403n__ans
naos47429733n__aos
napalms1144033napalms
napas75924353napa_s
naps66238583n__aps
nasals63312463nasals
navars92810573navars
nawabs1185063nawabs
nays75931593n__ays
nazis145216083naz_is
neaps75618323n_eaps
nears55529423n_ears
neats55931903n_eats
neems77316293n_eems
nemas75321573nema_s
neums75414253n_eums
nibs65028313ni__bs
nicad8312613nica_d
niches114419143niches
nicks114920493ni_cks
nicols8810243nicols
nidal65217103nida_l
nidate7313783nidate
nidates8311893nidates
nides65229133ni_des
nidus65913573ni_dus
nieces84112713nieces
nieves94311293nieves
nighs95013613ni_ghs
nights104117723nights
nihils937573nihils
nilgais845203nilgais
nilgaus844003nilgaus
nills54926673ni_lls
nils46132453ni__ls
nim57142953ni__m_
nimbus10377283nimbus
nines55937343ni_nes
ninjas1386303ninjas
ninons64913773ninons
ninths936933ninths
nipa69421633nipa__
nips65830923ni__ps
niseis63512023niseis
nisus56014393ni_sus
niters64624213niters
nites55736343ni_tes
nitons64614903nitons
nitres65519333nitres
nitros64214123nitros
nits45741643ni__ts
nival84915773niva_l
nixes124519623ni_xes
nixies135313873nixies
nizamate1943533nizamate
nizamates2043273nizamates
nomads94711603nomads
nomas74726413noma_s
noms65636403n__oms
nonas55126653nona_s
nopals84914023nopals
norms76019313n_orms
novas85215363nova_s
noways12127733noways
ogams84112683_ogams
oghams1245853oghams
pams85641763__pams
pians75126963pi_ans
pias66542553pi_a_s
pibals103813083pibals
picas94626523pica_s
pikas114218093pika_s
pilafs113511023pilafs
pilaus84114133pilaus
pilaws11399433pilaws
pimas94725103pima_s
pinas75434453pina_s
pipals104213643pipals
pitas77427673pita_s
pizazz1554223pizazz
pizzas1646983pizzas
praams10459643praams
prams96125513_prams
rams65950773__rams
reams75729623_reams
rials55026673ri_als
rias45540593ri_a_s
rims65936303ri__ms
rivals94213183rivals
riyals94111083riyals
roams74919613_roams
scams94423973_scams
scrams105216623scrams
seams75731663_seams
shams105829413_shams
sials54227243si_als
sigmas94111363sigmas
sikas94617023sika_s
simars84916933simars
simas75727553sima_s
sims65737173si__ms
sisals63013573sisals
sitars65417593sitars
sizar145214993siza_r
sizers155215813sizers
sizes146727763siz_es
slams74927903_slams
spams94922193_spams
steams84916903steams
tams67247933__tams
teams75726513_teams
thirams1236823thirams
ticals83214713ticals
tilaks1097353tilaks
titans63414913titans
trams75327673_trams
tzars144914273_tzars
unjams1555703unjams
unseams9338913unseams
vials85822383vi_als
vicars11712263vicars
vigas94817883viga_s
vims95423313vi__ms
vinals94716483vinals
vinas85126343vina_s
visas84317653visa_s
vitals94514303vitals
vivas114815023viva_s
vizard19458853vizard
vizards20377263vizards
vizirs18306713vizirs
vizors18328903vizors
whams135515643_whams
wigans104511703wigans
wigwams1643883wigwams
witans93412933witans
wizard19377713wizard
wizards20326403wizards
wizens186110263wizens
wizes174723343wiz_es
wizzes175110773wizzes
yams95330733__yams
zags146826683__zags
zaps156826893__zaps
zas126946833__za_s
zigzags1742273zigzags
ziram163912893ziram_

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162854.84323274.0
3Display Results2852850.0933064.5
 (SQL Overall)1786912855.07635203.1
 
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.