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

247 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
nutria63991(None) 
nutrias739811nutrias
anuria6313132anu_ria
atria56022352_atria
curia74523782cu_ria
latria62313612latria
nitric82512062nitric
nitrid72812232nitrid
nitril62511532nitril
noria55722182n_oria
nubia7311232nu_bia
outrig72812852outrig
putrid9311172putrid
stria55723212_stria
sutra54217932sutr_a
untrim8310682untrim
yttria954802yttria
agria65517143_agria
angaria8311583angaria
antra56521923antr_a
anurias7312253anu_rias
anuric8812113anu_ric
aporia8315863aporia
apteria9312923apteria
aquaria1638043aquaria
aria46245433__aria
asteria7316203asteria
atrial65418943_atrial
atrip75315753_atrip
attrit6315753attrit
aura45836253au_r_a
auric74521743au_ric
auris55331533au_ris
bothria1246453bothria
bura66139533bu_r_a
burial84117623bu_rial
burin75626063bu_rin
burka114617693bu_rka
burqa165013093bu_rqa
bursa74921523bu_rsa
butyric1445123butyric
butyrin1245813butyrin
ceria75125363_ceria
citric102812313citric
citrin82615413citrin
coria75828323_coria
cumbia12379893cumbia
cupric1249123cupric
curiae84518373cu_riae
curial84019153cu_rial
curie74533043cu_rie
curio74221213cu_rio
currie84317263currie
cutie76925933cut_ie
cutin75022783cut_in
cutis77723763cut_is
deutzia1743143deutzia
dulia61014983du_lia
dura55232113du_r_a
durian7312003du_rian
durra65315793du_rra
durrie73713263durrie
entia5318203ent_ia
estrin6315923estrin
extra1239003extr_a
feria85922713_feria
funkia1336343funkia
fusaria1046223fusaria
gloria71910553gloria
gutta64613383gut_ta
hubris11218973hubris
hutzpa2052813hutzpa
hydria13227903hydria
iatric8312173iatric
inertia7410203inertia
jura116024893ju_r_a
kerria10339923kerria
kukri835043kukri_
kukris934453kukris
kurta95113923ku_rta
latrias71913213latrias
lithia939333lithia
lubric1097983lubric
lurid64618973lu_rid
lustra6358893lustr_a
lutea54819073lut_ea
lutein6311263lutein
manubria1243493manubria
maria75032893_maria
matrix1539853matrix
metric10314683metric
minutia946423minut_ia
mudra83912433mudr_a
mura65633303mu_r_a
murid84520583mu_rid
murra74519083mu_rra
murrha11366453murrha
naira5314743nair_a
narial6317963n_arial
naric76824173n_aric
naris55735293n_aris
natrium948993natrium
natron64116023natron
neutral737923neutral
neutrino845223neutrino
neutron737763neutron
niterie7313743niterie
nitid61817833nit_id
nitre57519683nitr_e
nitres65519333nitres
nitride82811243nitride
nitrids8269633nitrids
nitrify1335793nitrify
nitrile73011373nitrile
nitrils72810703nitrils
nitrite72314463nitrite
nitro54914353nitr_o
nitros64214123nitros
nitwit938593nitwit
nori47133143n_ori_
norias65518203n_orias
noris54928273n_oris
nostril749303nostril
nota46830773not__a
notarial8410753notarial
nubbin10308293nubbin
nubias8310093nu_bias
nucha10229793nu_cha
nudie65118673nu_die
nudnik1153313nudnik
numeric1158193numeric
numina83510843numina
nuncio837973nuncio
nuptial946633nuptial
nurd56224343nu_r_d
nurds65518523nu_rds
nurl45327243nu_r_l
nurls55519683nu_rls
nurse54420123nu_rse
nut36651963nut___
nutant6316383nutant
nutate63017373nutate
nutlet64220563nutlet
nutlike113110113nutlike
nutmeat947953nutmeat
nutmeg9124613nutmeg
nutpick1543883nutpick
nutrient848353nutrient
nuts45032673nut__s
nutsier7329253nutsier
nutsy85711503nut_sy
nutted74316973nutted
nutter63918053nutter
nuttier73112023nuttier
nuttily10308633nuttily
nutting83316233nutting
nutty84816873nut_ty
ostia52315583ost_ia
ourie54027303ou_rie
outbid91411863outbid
outdid81210923outdid
outfit93014953outfit
outgrin8810553outgrin
outhit92818473outhit
outlie62419533outlie
outran63218893outran
outre53922203outr_e
outread82811093outread
outride82615683outride
outrigs82811263outrigs
outring84021023outring
outrival1145323outrival
outroar739513outroar
outrow9311183outrow
outrun63213303outrun
outsin63617563outsin
outsit63620893outsit
outvie92412803outvie
outwit93014593outwit
outwrit10411423outwrit
puparia1147353puparia
purda82914693pu_rda
puri65931443pu_ri_
purin75527593pu_rin
puris75332023pu_ris
putti76018743putti_
puttie84116303puttie
pyuria1136953pyuria
qualia1559563qualia
querida1744353querida
retia55326113ret_ia
retrial7615553retrial
retrim83514883retrim
ria36745513___ria
rubric1097823rubric
rutin55421343rut_in
scoria8513503scoria
sharia93116733sharia
striae65422273_striae
strip77524343_strip
sudaria847973sudaria
supra73614253supr_a
sura45740293su_r_a
surra55521343su_rra
sutras64818593sutras
sutta54015333sut_ta
tetra53417953tetr_a
tetri52716453tetri_
tetris62816293tetris
thoria93012893thoria
triac74116373__triac
triad65217723__triad
trial54926353__trial
trig55528163__trig
trim65329523__trim
trio45233343__trio
trip66830393__trip
tugrik1134283tugrik
tutorial847833tutorial
tutti54614673tutti_
tuttis63611373tuttis
ultra539363ultr_a
uncia75015163_uncia
unrig61711413_unrig
unrip72012863_unrip
untie54425493unt_ie
until53517743unt_il
untread857413untread
untried82615853untried
untrims938613untrims
untrod769853untrod
untrue6310773untrue
urbia7311143_urbia
urea46528063_u_rea
urial54823023_u_rial
uric63624943_u_ric
ursa44116913_u_rsa
uta37425583_ut__a
uteri51012983_uteri_
utopia8107883_utopia
varia85824213_varia
vitric112510113vitric
yautia937253yaut_ia
yttrias1044523yttrias
yttric1145433yttric
yurta86014253yu_rta
zoaria1548383zoaria

Search took 7 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.423422437.4
2DLD Change Limit1127162475.93618988.5
3Display Results2472470.0932655.9
 (SQL Overall)1786912476.45227695.4
 
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.