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

160 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
uakari104686(None) 
uakaris1146631uakaris
acari75020282_acari
laari54415712la_ari
makar115614972makar_
makars124612632makars
safari91110222safari
tamari8313382tamari
urari54619962u_rari
abaci94718843_abaci
abri65522213_a_bri
acarid95017063_acarid
afar76720783_afar_
afars85716513_afars
agar58726413_agar_
agaric93513623_agaric
agars66120643_agars
ajar116217703_ajar_
alar46340073_alar_
alarm76621423_alarm
alary86123443_alary
alkali10127553alkali
ambari103012163ambari
apart74330673_apart
aurar54420253aurar_
award97118043_award
aware86420023_aware
baker115629543baker_
bakers125323453bakers
bakery155911003bakery
bayard124411663bayard
bazar163816003bazar_
bazars174613113bazars
calami10313423calami
canard9314763canard
canary11314693canary
curari84414403curari
dalasi7610623dalasi
damar84117733damar_
damars93814993damars
datary10310243datary
dekare112811563dekare
denari710917353denari
eskar9457453eskar_
eskars10357593eskars
faker124824593faker_
fakers134219533fakers
fakery16509263fakery
fakir125111493fakir_
fakirs13468083fakirs
gazar154612983gazar_
gazars164811553gazars
guarani8106273guarani
haar77323493ha_ar_
haars85620473ha_ars
hadarim13117423hadarim
havarti1345053havarti
hazard1938403hazard
hegari1039513hegari
kabar114815553kabar_
kabars124513953kabars
kadi96224823__kadi
kaka76518683kaka__
kakapo1143853kakapo
kakas85117343kaka_s
kaki76520913__kaki
kami105823643__kami
karn86129413__karn
kart86750803__kart
kauri93811843ka_uri
kukri835043kuk_ri
labara83712893labara
lahar83114263lahar_
lahars94013163lahars
laker95432873laker_
lakers105225153lakers
lanai5319573lana_i
lari45839153__lari
lazar144113643lazar_
lazars153812393lazars
maar66025053ma_ar_
maars74621633ma_ars
maker114127813maker_
makers123921733makers
malar76424443malar_
malaria9313693malaria
malars85020683malars
mazard1838763mazard
navar83912733navar_
navars92810573navars
okapi1136613_okapi
ourari63413543ourari
padri85815163pa_dri
pakora1247283pakora
papyri1334903papyri
quaker193811623quaker_
quakers20309683quakers
quasar1536833quasar_
quasars1646903quasars
radar61316723radar_
radars71314663radars
raker94529793raker_
rakers104123573rakers
raki87127833rak__i
safaris101110663safaris
saker95132023saker_
sakers104125433sakers
saki85628473sak__i
salami8313103salami
salary9515213salary
samara8313853samara
sari45444043__sari
satara6315533satara
satori6415833satori
savarin10310003savarin
shikari1444493shikari
souari6311373souari
suffari1345503suffari
tabard9313333tabard
taka87623593taka__
takahe1335793takahe
takas95520683taka_s
taker95229003taker_
takers103923743takers
talar56225383talar_
talaria7412503talaria
talars66021683talars
tamarin9311893tamarin
tamaris9413573tamaris
tankard1267263tankard
tatami839183tatami
tatar56122063tatar_
tatars64619793tatars
tuatara745503tuatara
ukase9428493u_kase
ulnar56013983ulnar_
umami939883u_mami
unai44824783u_na_i
unarm7314453u_narm
unary8315993u_nary
unaware1038033unaware
unbar71913613unbar_
unbars82113033unbars
unfair936233unfair
unhair937333unhair
unwary1239823unwary
updart9310743updart
upward12147163upward
uraei53016083u_raei
urare56322553u_rare
uraris63817273u_raris
uteri51012983u_teri
vagary1337333vagary
vaward13498723vaward
wakame1535433wakame
waker125526593waker_
wakers134822493wakers
wakiki1233463wakiki
wasabi1154643wasabi
zaikai1943713zaika_i

Search took 8 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.1431249587.4
2DLD Change Limit1127161607.20315648.5
3Display Results1601600.0463478.3
 (SQL Overall)1786911607.39224173.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.