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

223 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
ab410674761a_b
ah513868791ah_
aha611246641aha
ahi68040231ahi
ahs68644821ahs
alb57342651alb
arb510448421arb
aa219179952a_a
aah616252962aah
aahs716428562aahs
aal39058672aal
aas310975392aas
aba512850952aba
abba810522642abba
abbe87627182abbe
abo59045962abo
abs59356072abs
aby810238062aby
ace59656832ace
ache96829822ache
achy126316092achy
act59557842act
ad311975032a_d
add510132362add
ado49146872ado
ads49755732ads
adz1312332862adz
ae212590292a_e
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
age47154332age
agha87417302agha
ago48845522ago
ags47551662ags
ahed89536252ahed
ahem97225362ahem
ahis76135382ahis
ahoy101919182ahoy
ai211288392a_i
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
al210674042a_l
ala312463602ala
alba68328332alba
albs68628572albs
ale36572342ale
all36148232all
alp56641132alp
als36663022als
alt36467962alt
am411875562a_m
ama510853302ama
ambo88225132ambo
ami56646802ami
amp77541022amp
amu58237322amu
an211879072a_n
ana39559822ana
and47244162and
ane37866942ane
ani37751172ani
ant37270782ant
any68440482any
ape57251182ape
apo511142122apo
app76827602app
apt57352542apt
ar211379382a_r
arbs66834732arbs
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
as211083072a_s
ash67944602ash
ashy107717352ashy
ask77130702ask
asp57235342asp
ass37844062ass
at212393402a_t
ate37059242ate
att35454652att
auk76234142auk
ava610139322ava
ave67748702ave
avo68936232avo
aw512563402a_w
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axe108239492axe
ay511773892a_y
aye67151762aye
ays67050292ays
azo128233392azo
bah87755352bah_
baht96740012baht
barb85240062barb
bib77045922bib
bob76755662bob
bub76343972bub
cab78355402cab
carb85143162carb
chi86228652chi
chub115516412chub
cob710258752cob
cub76940942cub
dab67455562dab
dah78148982dah_
dahl87019222dahl
dahs88231812dahs
darb76033532darb
daub77423442daub
deb66342692deb
dib65746932dib
dub66642202dub
ebb72418622ebb
eh58339962eh_
fab87453132fab
fib86344262fib
fob86748332fob
fub86337392fub
gab67155992gab
gamb96331842gamb
garb75332672garb
ghi77019882ghi
gib66443522gib
gob68950892gob
ha510259942_ha
habu97325482habu
had77658762had
hae67364002hae
hag77255742hag
hah910655222hah
haha107821062haha
hahs108333362hahs
haj138140602haj
ham86363282ham
hao67251122hao
hap87360052hap
has67372652has
hat67289962hat
haw97153272haw
hay97358772hay
he58151952_he
hi57947582_hi
hm78126732_hm
ho510258272_ho
hob87550922hob
hub86437482hub
iamb86623722iamb
jab128444112jab
jamb155523852jamb
jib125835962jib
job128041772job
kab97145852kab
khi106318302khi
kob99442382kob
lab58864782lab
lamb86832142lamb
lib57750262lib
lob57154462lob
mho86624622mho
mib76946102mib
mob78651912mob
nab56954922nab
nah69847002nah_
neb57238622neb
nib56745182nib
nob58954422nob
nub56439142nub
oh57447002oh_
ohm86523012ohm
oho66534382oho
ohs66232312ohs
orb55736862orb
pah88853592pah_
phi86524202phi
pht86030522pht
pub76037692pub
rah68052402rah_
reb55844962reb
rho65924832rho
rib56848022rib
rob56754302rob
rub56342822rub
sab56563202sab
sahib10314752sahib
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shy96728192shy
sib56850302sib
sob57857942sob
sub55445552sub
tab57460322tab
tahr75217152tahr
the67436052the
tho67433962tho
thy97022912thy
tub55640032tub
uh57429852uh_
urb55731102urb
wab87051832wab
web85735562web
wha96422072wha
who95526772who
why126920012why
yah99046352yah_
yob87945272yob

Search took 2 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 Filter178691140840.1261418182.5
2DLD Change Limit140842230.89015824.7
3Display Results2232230.0464847.8
 (SQL Overall)1786912231.062168258.9
 
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.