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

144 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
tabu6632849(None) 
babu85829231babu
habu97325481habu
tab57460321tab_
tabs66842981tabs
tabun75914371tabun
tabus74820921tabus
tau36856901ta_u
ab410674762_ab_
aba512850952_aba
abo59045962_abo
abs59356072_abs
abut66834952_abut
aby810238062_aby
amu58237322_amu
baba88828352baba
babe86835822babe
babul96317712babul
babus95620332babus
baby116723682baby
bubu85022672bubu
cab78355402cab_
cabs86739422cabs
dab67455562dab_
dabs77139402dabs
daub77423442daub
eau37450942ea_u
fab87453132fab_
fabs98635862fabs
gab67155992gab_
gabs76740422gabs
gaby107123192gaby
habus106317142habus
haku116923892haku
jab128444112jab_
jabs135830092jabs
kab97145852kab_
kabs107130842kabs
kagu95418112kagu
lab58864782lab_
labs67145122labs
latu47934182latu
mabe85733362mabe
nab56954922nab_
nabe66029492nabe
nabs66236192nabs
raku85423772raku
sab56563202sab_
sabe66140572sabe
sabs66643742sabs
sau36356572sa_u
stab67329932stab_
stabs76221382stabs
ta211662452ta__
tabby125213892tabby
taber73825822taber
tabes76033922tabes
tabid84418262tabid
tabla73318362tabla
table75429602table
taboo73418092taboo
tabor75518392tabor
tabour84011322tabour
tabued94310402tabued
tabuli839362tabuli
tabuns8489222tabuns
tace65342512tace
tach96132752tach
tack106536292tack
taco67031352taco
tact67349032tact
tad47959822ta_d
tads57143942tads
tae38267052ta_e
tael46030712tael
tag47259492ta_g
tags55545232tags
tahr75217152tahr
tail45443652tail
tain45548072tain
taj106442192ta_j
taka87623592taka
take84739262take
tala45938052tala
talc66226812talc
tale46154162tale
tali46837162tali
talk86230092talk
tall47240212tall
taluk94812872taluk
talus55423262talus
tam58663422ta_m
tambur10358712tambur
tame66343662tame
tamp86133002tamp
tams67247932tams
tan37167572ta_n
tang56138672tang
tank85134022tank
tans46154822tans
tao38358952ta_o
taos45541002taos
tap57663872ta_p
tapa65129142tapa
tape64538142tape
taps66050672taps
tar37570692ta_r
tare45957622tare
tarn46842722tarn
taro46846912taro
tarp66936412tarp
tars46763952tars
tart47566182tart
tas38477102ta_s
task85326652task
tass45640572tass
tat37690292ta_t
tate44748602tate
tats46858132tats
taus46342732taus
taut47048962taut
tav66043212ta_v
tavs75630972tavs
taw610155452ta_w
taws75641592taws
tax109449152ta_x
taxa116820092taxa
taxi117124762taxi
taxus125512482taxus
thou76722212thou
thru76818942thru
toby96322292toby
tofu76921332tofu
tolu45529152tolu
tub55640032tub_
tuba65422362tuba
tube65828662tube
tubs65430062tubs
tutu48423172tutu
vatu76524332vatu
vau66840872va_u
wab87051832wab_
wabs97337232wabs
zebu153414722zebu

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 Filter178691298720.280638182.1
2DLD Change Limit298721440.89033564.0
3Display Results1441440.0334363.6
 (SQL Overall)1786911441.203148537.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.