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

248 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
urinals761025(None) 
urials64415191uri_als
urinal6614121urinal_
bridals1038622bridals
burials93612082buri_als
finals94316162_finals
ordinals946752ordinals
rials55026672_ri_als
rivals94213182_rivals
riyals94111082_riyals
spinals93911862spinals
trials64319882tri_als
tribals9610752tribals
trinal6516962trinal_
turbinals1144252turbinals
uranyls1034452uranyls
urial54823022uri_al_
urinary1037242urinary
urinate7315362urinate
urinates8314132urinates
urines64724122urin_es
urinous7310082urinous
vinals94716482_vinals
adrenals946303adrenals
aerials74017553aeri_als
animals94111703animals
annals66415923_annals
apicals1159923apicals
arenas65021993arena_s
argals75517713ar_gals
arias55438023ari_a_s
ariels65119373ari_els
arils58732203ari__ls
arrivals1145933arrivals
arsenals847733arsenals
binal75323823_binal_
briars84814823bri_ars
bridal9511453bridal_
brills84916293bri_lls
brindle104210103brindle
brindles113710223brindles
briners94315633briners
brines85028853brin_es
brings94618433brin_gs
brinies93317913brinies
brinks124616313brin_ks
brins75533973brin__s
bromals1139743bromals
burial84117623buri_al_
burins84221893burin__s
canals84421663_canals
cardinals1247993cardinals
carinal94318233carinal_
carinas93622403carina_s
chinas115119403china_s
clinal8311553clinal_
coronals103312893coronals
craals84113303cr_aals
crenels93711013crenels
criminals1346293criminals
cringes103215503cringes
cringle103010353cringle
cringles11329463cringles
crinkle13359413crinkle
crinkles14269163crinkles
crinkly16387523crinkly
crinums1135863crinums
curial84019153curi_al_
curtals93111623cur_tals
denials84114133denials
dials64925343_di_als
dinars75417563_dinars
dirndls933893dirndls
diurnals943803diur_nals
drills74414203dri_lls
drinks116810713drin_ks
drivels11397923drivels
durians839573duri_ans
epinaos936283epinaos
ericas8315463erica_s
eringos836913eringos
farinas103215233farina_s
final83922033_final_
finale94116763_finale
finales104016013_finales
finalis103313663_finalis
finials103210153_finials
friars93812093fri_ars
frills94414223fri_lls
fringes113514103fringes
frivols1334743frivols
frontals1146273frontals
gingals9109313_gingals
graals74112913gr_aals
grills74314803gri_lls
grinds84511843grin_ds
gringas938043gringas
gringos936673gringos
grins65427223grin__s
hymnals1543523hymnals
jarinas143712183jarina_s
jingals1588073_jingals
journals1574353jour_nals
juvenals1842773juvenals
kinas95626913_kina_s
kraals10378433kr_aals
krills104211283kri_lls
laminals10339303laminals
linacs8310813_linacs
luminal93711003luminal_
luringly1237323luringly
marginals1246003marginals
marinas93519383marina_s
menials94015683menials
minas75434113_mina_s
murals84016753mur__als
murines93718223murin_es
musicals1247093musicals
nominals10278613nominals
orals55826483or__als
orbitals1045713orbitals
orcinols1044413orcinols
ordeals877993ordeals
ordinal838633ordinal_
oriels64914623ori_els
orientals946903orientals
origans839973origans
originals1044843originals
orinasals942473orinasals
outrivals1243893outrivals
phials1158873phi_als
pibals103813083_pibals
pinas75434453_pina_s
pineals93212843_pineals
pipals104213643_pipals
prills84015613pri_lls
primal104014623primal_
primas104418103prima_s
princes113015143princes
prinks124315383prin_ks
prints84320103prin_ts
puranas9712643purana_s
purines94420763purin_es
purins83722653purin__s
puritans1037633puritans
quinols16297243quinols
quintals17288003quintals
ratals64219583_ratals
reals55038653_r_eals
renails74917263_renails
renal55929503_renal_
rentals74017473_rentals
retinals85612963retinals
rhinal9510193rhinal_
rial45938093_ri_al_
rias45540593_ri_a_s
ribald9209293_ribald
ribalds10236673_ribalds
riels55121333_ri_els
rills55032713_ri_lls
rinds64826143_rin_ds
ringhals1256263_ringhals
rings65029173_rin_gs
rinks94827103_rin_ks
rins46153193_rin__s
rinses64720383_rinses
rituals738353_rituals
rival85216503_rival_
riyal84413433_riyal_
royals93711263_royals
ruanas6311263ruana_s
ruinable1039263ruinable
ruinate7312833ruinate
ruinates8311883ruinates
ruiners74213023ruiners
ruinous739763ruinous
ruins55822033ruin__s
ruminal9289993ruminal_
runnels7329153runnels
serials73919743seri_als
sials54227243_si_als
signals8359163signals
sisals63013573_sisals
spinal84915313spinal_
spinels94512443spinels
spirals93212513spirals
spitals93011593spitals
springals1245373springals
survivals1543013survivals
terminals1147453terminals
ticals83214713_ticals
tincals93610643_tincals
trenails869843trenails
triacs83913223tri_acs
triads74513533tri_ads
trial54926353tri_al_
tribal8611133tribal_
tribunals11103523tribunals
trills64319853tri_lls
trinary1039173trinary
trindle83311363trindle
trindles93211683trindles
trines64132563trin_es
triols66117803tri_ols
tronas63816903trona_s
turbinal1045623turbinal_
ulnas55716533u_lna_s
umiacs1035663umi_acs
umiaks1244953umi_aks
umiaqs1733003umi_aqs
unais53420773u__nais
unaus53216573u__naus
uncials92510523uncials
uncinal959963uncinal_
unnails738223u_nnails
unseals73212573unseals
unsnags835463unsnags
unsnaps935423unsnaps
unsnarls894883unsnarls
uracils939373uracils
uranias72113813uranias
uranous7310733uranous
uranyl936293uranyl_
urbias839093urbia_s
ureal56722683ur_eal_
ureas55826013ur_ea_s
urgingly1336733urgingly
urinalyses1362323urinalyses
urinalysis1351893urinalysis
urinaries949203urinaries
urinated9311613urinated
urinator847843urinator
urinators947633urinators
urine55026593urin__e
urinose738483urinose
urns46323893ur_n__s
usuals637783u_suals
veinal93812963veinal_
vials85822383_vi_als
vinal85725813_vinal_
vinas85126343_vina_s
vinyls12467003_vinyls
virginals1343203virginals
vitals94514303_vitals
wrings104012973wrin_gs
wrinkle14296923wrinkle
wrinkles15296693wrinkles
wrinkly17295753wrinkly

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.1531167915.0
2DLD Change Limit1340272489.17314611.0
3Display Results2482480.1861333.3
 (SQL Overall)1786912489.51218785.8
 
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.