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

218 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
umiaqs173300(None) 
umiacs1035661umiacs
umiaks1244951umiaks
umiaq1656821umiaq_
amias75831472amia_s
umiac938962umia_c
umiack1435172umiack
umiacks1534012umiacks
umiak1137672umia_k
urials64415192urials
alias55834603alia_s
amahs107819063am_ahs
amas67746293am_a_s
amass77119683am_ass
amia66836903amia__
amices105018013amices
amicus103810003amicus
amides95722663amides
amids85627513ami_ds
amies76837693ami_es
amigas95912173amigas
amigos94511213amigos
amines84727983amines
amins75534323ami_ns
amirs75924923ami_rs
amis66445323ami__s
amiss75823073ami_ss
arias55438023aria_s
avians93711563avians
bias64738163_bia_s
bimahs13508303bimahs
bimas95521743bima_s
briars84814823briars
burials93612083burials
chias104625523chia_s
chiaus113611313chiaus
cumbias13338963cumbia_s
cumins103314933cumi_ns
dials64925343_dials
dulias71212743dulia_s
dumas85420433dum_a_s
durians839573durians
emails84412343emails
embars103812883embars
embays131408333embays
emirs76116163emi_rs
emits75421473emi_ts
fiars86720833_fiars
fiats85324483_fiats
friars93812093friars
glias64618493glia_s
guaiacs1054353guaiacs
gummas114810513gumma_s
humans112312433hum_ans
iliads7448673iliads
imams91511113im_ams
imides94515343imides
imids86015143imi_ds
imines84918353imines
ixias12488373ixia_s
jumbals18106533jumbals
kaiaks937043kaiaks
kumiss1235923kumi_ss
lamias85020613lamia_s
liars54723163_liars
limans84816303limans
limas75627633lima_s
lumas75622913lum_a_s
lumbars11289763lumbars
maars74621633_maars
macs86742513_m_acs
mads76845373_m_ads
maes66948403_m_aes
mags75444533_m_ags
maids86327143_maids
mails76037783_mails
maims96321793_maims
mains75635113_mains
mairs76228303_mairs
mans66354553_m_ans
maps86141053_m_aps
mars66261873_m_ars
mas58175823_m_a_s
mass66044943_m_ass
mats65460293_m_ats
maws96437143_m_aws
mays96940033_m_ays
meads85425323_meads
meals75933373_meals
means75831233_means
meats75034053_meats
miaou7513083_miaou
miaous8511693_miaous
miaow1058353_miaow
miaows1145473_miaows
miasm91211093_miasm
miasms1097383_miasms
miaul71612123_miaul
miauls8178713_miauls
mibs85330483_mi_bs
micas96823053_micas
micks135525373_micks
mics87435153_mi_cs
midis85923413_midis
mids76541783_mi_ds
miens76118303_miens
miffs134512883_miffs
miggs96311373_miggs
migs76935323_mi_gs
mikes115129893_mikes
milds86422053_milds
miles74645073_miles
milks115020583_milks
mills75435053_mills
milos75428013_milos
mils66045333_mi_ls
milts75430713_milts
mimes95732023_mimes
minas75434113_minas
minds85427123_minds
mines75651953_mines
minis75432993_minis
minks115829273_minks
mints76834043_mints
minus75223933_minus
mips85534083_mi_ps
mires75640883_mires
mirks115122143_mirks
mirs66940573_mi_rs
mis58162623_mi__s
mises74740563_mises
misos76523293_misos
miss65339423_mi_ss
mists76633903_mists
mites75141803_mites
mitis75425993_mitis
mitts75523753_mitts
mixes147224403_mixes
moans74624373_moans
moas65545343_moa_s
moats75827643_moats
murals84016753murals
muras75329563mura_s
naiads739013naiads
nubias8310093nubia_s
numbats1137673numbats
obias76116863obia_s
ohias84415573ohia_s
omits75018263omi_ts
oomiacs1135683oomiacs
oomiaks1344123oomiaks
phials1158873phials
pians75126963_pians
pias66542553_pia_s
pimas94725103pima_s
pumas95121563pum_a_s
pumices1338273pumices
raias54631123raia_s
rials55026673_rials
rias45540593_ria_s
rumbas102512013rumba_s
rupiahs1253333rupiahs
sials54227243_sials
simars84916933simars
simas75727553sima_s
simians959203simians
smears84714433smears
smiles84522293smiles
smirks124910123smirks
smites83921923smites
smiths114711023smiths
sumacs105512103sum_acs
summas104313163summa_s
triacs83913223triacs
triads74513533triads
trials64319883trials
uhlans937573uhlans
ulans54921303u_lans
ulnas55716533ulna_s
ulvas84511503ulva_s
umami939883um_ami
umamis1038273umamis
umbels104510593umbels
umbers104215213umbers
umbles103817493umbles
umbos94613073um_bos
umbras1038643umbras
umlaut838033umlaut
umlauts943193umlauts
umpires1137813umpires
umps85721943um__ps
unais53420773u_nais
unaus53216573u_naus
unbans81912623unbans
unbars82113033unbars
uncaps1039813uncaps
uncials92510523uncials
unhats91110623unhats
unions64216753unions
unites65024853unites
units54923433uni_ts
unjams1555703unjams
unlays93810493unlays
unmans82211993unmans
unmixes16197753unmixes
unsays9399543unsays
upas68322383u_pa_s
urbias839093urbia_s
ureas55826013urea_s
uremias9249503uremia_s
urial54823023uria_l
urinals7610253urinals
urines64724123urines
usuals637783usuals
utas45924953u_ta_s
uveas84912283uvea_s
vials85822383_vials
zamias174212923zamia_s

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 Limit1127162185.31321215.1
3Display Results2182180.0633460.3
 (SQL Overall)1786912185.51632395.0
 
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.