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

281 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
bani6533496(None) 
ani37751181_ani
ban58366841ban_
band76740921band
bane65250431bane
bang74837011bang
bank105835751bank
bans66555141bans
rani46640111rani
abaci94718842abaci
abri65522212abri
ahi68040232_ahi
ai211288402_a_i
ain37579102_ain
ami56646812_ami
an211879082_an_
ana39559832_ana
and47244182_and
ane37866952_ane
anil46437432_anil
anis45746472_anis
ant37270792_ant
anti45536362_anti
any68440492_any
ba49962342ba__
baa510650422ba_a
baal67033112baal
baas66844672baas
baba88828352baba
babe86835822babe
babu85829232babu
baby116723682baby
bach116131392bach
back125535762back
bad67763162ba_d
bade75140892bade
bads77048872bads
baff124632272baff
bag67059222ba_g
bagnio937522bagnio
bags76645502bags
bah87755352ba_h
baht96740012baht
bail65042802bail
bait66556002bait
bake105637512bake
bal56662722ba_l
bald76432902bald
bale66353842bale
balk105132222balk
ball66043322ball
balm85534202balm
bals66354042bals
bam78560142ba_m
bams87044452bams
banal75925992banal
banco94019392banco
banda85223112banda
bandit93821132bandit
bands85233432bands
bandy114824192bandy
baned85436352baned
banes74945582banes
bangs85627782bangs
banian8315382banian
baning95127832baning
banish111416062banish
banjo143812442banjo
bankit123617042bankit
banks115527902banks
banns75321232banns
banty106624002banty
banzai1737652banzai
bap76455842ba_p
baps86040842baps
bar58070552ba_r
barb85240062barb
bard75648862bard
bare65460522bare
barf95844412barf
baric96125692baric
bark106242152bark
barm86739612barm
barn66444642barn
barns76335142barns
barny105821732barny
bars66564092bars
bas58681752ba_s
base64847022base
bash915240162bash
basic96220522basic
basil75122272basil
basin75026922basin
basis75429862basis
bask105131422bask
bass66146782bass
bassi77019322bassi
bast66362412bast
bat510988952ba_t
bate66552422bate
bath95940082bath
batik11614732batik
bats66962332bats
batt65053872batt
baud74928422baud
bawd105520842bawd
bawl95326062bawl
bay89661642ba_y
bays97143912bays
bean66443862bean_
beanie83618592beanie
beano75421552beano
beans75734692beans
ben56554922ben_
bend76435262bend
bene66439492bene
benni74715362benni
bens65945702bens
bent67759912bent
bhang115512922bhang
bi48046482b__i
biali73419072biali
bidi78226602bidi
bin56658652bin_
bind76234522bind
bindi85617022bindi
bine66650872bine
binit76431582binit
bins66548262bins
bint67355052bint
blain75421792blain
bland85320452bland
blank115418552blank
blin67228172blin
blini75519272blini
bond75334362bond
bone65949322bone
bong75633412bong
bonk105531712bonk
bony96732082bony
brain76229382brain
bran65740382bran_
brand85124492brand
brank115222282brank
brans75437432brans
brant74742172brant
bravi104715752bravi
brin67038192brin
bun56348142bun_
buna64730722buna
bund75530662bund
bung75730632bung
bunk105731352bunk
bunn65023652bunn
buns66243722buns
bunt65850852bunt
bwana10310242bwana
cadi75732192cadi
cain65643912cain
can57760142can_
cane66653122cane
canid85526342canid
cans65050852cans
cant66362032cant
coni65534802coni
dan46859672dan_
dang65131552dang
danio6319782danio
dank95828242dank
dans56748152dans
deni56929392deni
fain75840562fain
fan67158862fan_
fane75343572fane
fang85432562fang
fano75831692fano
fans76247372fans
gadi66329732gadi
gain56042162gain
gan48060132gan_
gane55145302gane
gang66031982gang
garni6315702garni
haji148520192haji
hand86833712hand
hang85535562hang
hank115134142hank
hant75461592hant
jane115031482jane
kadi96224842kadi
kain85334302kain
kaki76520922kaki
kami105823662kami
kana85928552kana
kane85133982kane
kanji1647452kanji
lain46146282lain
lanai5319572lanai
land56337312land
lane45153332lane
lang56637392lang
lank84734452lank
lari45839152lari
lati46438272lati
magi76329532magi
main65345522main
man57465872man_
mana65341962mana
mane65052032mane
mania75634152mania
manic94629442manic
mano66536812mano
mans66354552mans
many95731862many
maxi137023562maxi
mini65634572mini
muni65824412muni
nan37854882nan_
nana46632902nana
nans46139402nans
naoi46024632naoi
nazi136219872nazi
padi76331792padi
pain65647242pain
pan58466452pan_
pane64950292pane
pang75336302pang
panic93923902panic
pans65855732pans
pant66061262pant
qadi145621112qadi
ragi56032282ragi
rai37658222ra_i
rain46251732rain
raki87127832raki
rami66034092rami
ran38266622ran_
rand55839572rand
rang56939172rang
ranid66429332ranid
ranis55235842ranis
rank85135532rank
rant45864682rant
sadi55834652sadi
sain45551292sain
saki85628482saki
sand55338472sand
sane45954342sane
sang55441242sang
sank85236832sank
sans45153362sans
sari45444042sari
sati45539332sati
tain45548072tain
tali46837162tali
tan37167582tan_
tang56138692tang
tank85134032tank
tans46154832tans
taxi117124762taxi
unai44824782unai
vagi86719362vagi
vain75233002vain
van66246332van_
vane75534692vane
vang84926052vang
vans76236742vans
wadi86228182wadi
wain75840202wain
wan66761942wan_
wand85833882wand
wane76344722wane
wank115632512wank
wans76452272wans
want76156172want
wany106432362wany
yagi86922242yagi
yang85626082yang
yank115423672yank
yoni77524392yoni
zany167316992zany

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 Limit298722810.86034734.9
3Display Results2812810.0634460.3
 (SQL Overall)1786912811.203148537.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.