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 “ahi” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

279 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
ahi6804023(None) 
ah513868791ah_
aha611246641aha
ahis76135381ahis
ahs68644821ahs
ai211288391a_i
ami56646811ami
ani37751181ani
chi86228651chi
ghi77019881ghi
hi57947581_hi
khi106318301khi
phi86524201phi
aa219179952a_a
aah616252962aah
aahs716428562aahs
aal39058672aal
aas310975392aas
ab410674762a_b
aba512850952aba
abo59045962abo
abri65522212abri
abs59356072abs
aby810238062aby
ace59656832ace
ache96829822ache
achy126316092achy
acid77533392acid
act59557842act
ad311975032a_d
add510132362add
adit56443652adit
ado49146872ado
ads49755732ads
adz1312332862adz
ae212590292a_e
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
age47154332age
agha87417302agha
agin56132712agin
agio57828452agio
ago48845522ago
ags47551662ags
ahed89536252ahed
ahem97225362ahem
ahing98928352ahing
ahoy101919182ahoy
aid49269082aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
akin86328032akin
al210674042a_l
ala312463602ala
alb57342652alb
ale36572342ale
alif76242142alif
alit46155692alit
all36148232all
alp56641132alp
als36663022als
alt36467962alt
am411875562a_m
ama510853302ama
amia66836902amia
amid77036352amid
amie66339852amie
amin66042252amin
amir65129752amir
amis66445322amis
amp77541022amp
amu58237322amu
an211879082a_n
ana39559832ana
and47244172and
ane37866952ane
anil46437432anil
anis45746462anis
ant37270792ant
anti45536362anti
any68440492any
ape57251182ape
aphid115515392aphid
aphis105917132aphis
apo511142122apo
app76827602app
apt57352542apt
ar211379382a_r
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
aria46245422aria
arid57642712arid
aril45843022aril
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
as211083072a_s
asci66519142asci
ash67944602ash
ashy107717352ashy
ask77130702ask
asp57235342asp
ass37844062ass
at212393402a_t
ate37059242ate
att35454652att
auk76234142auk
ava610139322ava
ave67748702ave
avid88325962avid
avo68936232avo
aw512563402a_w
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axe108239492axe
axil116424452axil
axis116127912axis
ay511773892a_y
aye67151762aye
ayin76331742ayin
ays67050292ays
azo128233392azo
bah87755352bah_
baht96740012baht
bani65334962bani
bi48046472_bi
cadi75732182cadi
chai95929902chai
chia96026622chia
chic115925202chic
chid106626402chid
chin96934742chin
chip116726422chip
chis95933312chis
chit96937462chit
dah78148982dah_
dahl87019222dahl
dahs88231812dahs
dashi95013112dashi
dui46433382dui
eh58339962eh_
elhi7612402elhi
gadi66329722gadi
ghis85020162ghis
ha510259942_ha
had77658762had
hae67364002hae
hag77255742hag
hah910655222hah
haha107821062haha
hahs108333362hahs
haik115526982haik
hail74839062hail
hair76330142hair
haj138140602haj
haji148520192haji
ham86363282ham
hao67251122hao
hap87360052hap
has67372652has
hat67289962hat
haw97153272haw
hay97358772hay
he58151952_he
hic86540562_hic
hid76248382_hid
hie67652702_hie
him86247662_him
hin67559562_hin
hip86750432_hip
his66359502_his
hit66569192_hit
hm78126732_hm
ho510258272_ho
kadi96224832kadi
kaki76520912kaki
kami105823642kami
khis117017982khis
ki67537962_ki
koi77534752koi
lari45839152lari
lathi85417202lathi
lati46438272lati
lei36846382lei
li29948752_li
magi76329532magi
maxi137023562maxi
mho86624622mho
mi48249052_mi
nah69847002nah_
naoi46024632naoi
nazi136219872nazi
obi57127732obi
oh57447002oh_
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482_oi
padi76331782padi
pah88853592pah_
phis95724902phis
phiz186718842phiz
pht86030522pht
pi48145362_pi
poi57244662poi
psi56621622psi
qadi145621102qadi
qi116526902_qi
ragi56032282ragi
rah68052402rah_
rai37658222rai
raki87127832raki
rami66034092rami
rani46640112rani
rei35647252rei
rho65924832rho
sadi55834642sadi
sahib10314762sahib
saki85628482saki
sari45444042sari
sati45539332sati
sei36048932sei
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
shri76021702shri
shy96728192shy
si29149572_si
ski74925692ski
spahi10311142spahi
sri35634002sri
tahr75217152tahr
tali46837162tali
taxi117124762taxi
the67436052the
thin76732392thin
thio77225412thio
thir76420542thir
this76027382this
tho67433962tho
thy97022912thy
ti28448292_ti
tui37034022tui
uh57429852uh_
vagi86719362vagi
wadi86228172wadi
wha96422072wha
whid115418872whid
whig115516422whig
whim126220532whim
whin105225692whin
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
who95526772who
why126920012why
xi98128162_xi
yagi86922242yagi
yah99046352yah_

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140842790.39036112.8
3Display Results2792790.0634428.6
 (SQL Overall)1786912790.703254183.5
 
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.