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

260 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
kanbans133772(None) 
kanban1238621kanban_
banians9312032banians
banyans1237912banyans
cancans11311872cancans
kababs14409772ka_babs
kabars124513952ka_bars
kaftans14185352kaftans
kalians11310182kalians
kanas95326912kan_a_s
kantars11310032kantars
kasbahs1634362kasbahs
mannans93611522mannans
randans8313212randans
unbans81912622_unbans
wangans1149502wangans
abas68642083_a_ba_s
abbas95918643_abba_s
alans55636173_a_lans
albas75925393_alba_s
anabas8314083_anabas
anas46649863_an_a_s
anears63717183_anears
angas65827983_anga_s
anions64123033_anions
anlas55626933_anla_s
annals66415923_annals
annas55824883_anna_s
anoas57226493_anoa_s
antas55432033_anta_s
anurans73810553_anurans
anyons94513503_anyons
atmans84413963_atmans
avians93711563_avians
azans146516883_a_zans
babas96325733ba_ba_s
banana83213413ban_ana
bananas93312223ban_anas
bandana10179463bandana
bandanas11178573bandanas
bandas95120543banda_s
banian8315383banian_
banns75321233ban__ns
bans66555133___bans
bantams1149063bantams
banyan1139483banyan_
banzais1837163banzais
baobabs1044443baobabs
beanbags1342863beanbags
bonbons1139333bonbons
cabals104020153ca_bals
cabana103913563ca_bana
cabanas112413033ca_banas
cabins104418923ca_bins
caftans12179443caftans
caimans113811783caimans
callans94518473callans
canals84421663can_als
cancan10314103cancan_
cannas84518403canna_s
cannons94412883cannons
canons85522063can_ons
cantals93919573cantals
cantons95221203cantons
canvas113813333canva_s
canvass12376873canvass
canyons124511593canyons
captans111612053captans
carbarns1238563carbarns
carbons115418943carbons
casbahs1436463casbahs
caymans14349513caymans
corbans11313173corbans
damans94715983da_mans
darbars10510093darbars
fangas105017193fanga_s
fanions103713073fanions
fanons96115213fan_ons
gambas115817513gamba_s
gangbang1342963gangbang
gangbangs1442623gangbangs
ganjahs18104003ganjahs
ganjas14149113ganja_s
gasbags1135473gasbags
gobans94412043_gobans
handbags15116363handbags
hangars114313483hangars
hansas94616043hansa_s
hanumans1344943hanumans
hatband1346823hatband
hatbands1446283hatbands
hazans183411653ha_zans
hazzans18215783hazzans
henbane1237353henbane
henbanes1336563henbanes
honans94814503hon_ans
japans1539823ja_pans
jawans1657843ja_wans
kaas86531843ka__a_s
kabab134814443ka_ba_b
kabaka11348503ka_baka
kabakas12367403ka_bakas
kabala124011553ka_bala
kabalas133911063ka_balas
kabar114815553ka_ba_r
kabaya15387123ka_baya
kabayas16316803ka_bayas
kabbala1584613kabbala
kabbalas1674353kabbalas
kabobs14439303ka_bobs
kabs107130843ka_b__s
kaftan13185823kaftan_
kahunas1473953kahunas
kaiaks937043ka_iaks
kains96125643ka__ins
kakas85117343ka_ka_s
kalams12310603ka_lams
kalian10312163kalian_
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
kamsins1346963kamsins
kana85928523kan_a__
kanaka9357523kan_aka
kanakas10327213kanakas
kanes95529373kan__es
kanjis1735963kan_jis
kantar10311153kanta_r
kanzus1944603kan_zus
kaolins1139363kaolins
kaons95014853ka__ons
kapas116021733ka_pa_s
kappas144410363kappa_s
karats106420493ka_rats
karmas123013733karma_s
karns96624143ka__rns
kasbah1535183kasba_h
kashas133311903kasha_s
katas95922093ka_ta_s
kations114013663kations
kavas125919953ka_va_s
kavass13517303ka_vass
kayaks1236333ka_yaks
kbars114612603k__bars
kebabs14418513k_ebabs
kebars124112493k_ebars
kenafs1337113ken_afs
khans124615173k__hans
kinas95626913kin_a_s
kinins104014583kin_ins
kitbags1443883kitbags
knaps115511173k_n_aps
knars94416113k_n_ars
kneads11357093k_neads
knowns13426443k_nowns
koans95818623k__oans
kurgans12145653kurgans
kwanzas2342053kwanza_s
lagans75717783la_gans
lallans74113533lallans
lanais6316793lan_ais
landaus8310343landaus
lantana739603lantana
lantanas838263lantanas
lauans65113533la_uans
longans84510813longans
lungans8399053lungans
magians10310753magians
mambas125716243mamba_s
manana84816073man_ana
mananas93414733man_anas
manas76240423man_a_s
manats84623463man_ats
mangas94122923manga_s
maniacs114313063maniacs
manias84029033mania_s
mannan85413623mannan_
mannas85019803manna_s
mantas85725363manta_s
manuals9311213manuals
minyans1237263minyans
naans55815253__naans
nanas55928633nan_a_s
nandins8312003nandins
nankins1159053nankins
nans46139393__n_ans
nonbank1345903nonbank
nonbanks1445033nonbanks
nonfans1037533nonfans
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
pandani1039903pandani
pandanus1136433pandanus
pandas95521963panda_s
pangas99921103panga_s
pangens103112063pangens
parians93519733parians
partans94418283partans
pavans115715593pa_vans
qanats154112813qan_ats
rabats83116223ra_bats
rabbins112811343rabbins
radians83013823radians
ragbags1135113ragbags
raglans82410133raglans
rainband1144663rainband
rainbands1244193rainbands
randan7315253randan_
ratans63819373ra_tans
ratbags1035763ratbags
rattans73411953rattans
sabals84618863sa_bals
sabbats1138633sabbats
sabins85521983sa_bins
sambals115213483sambals
sambars115113843sambars
sambas104219263samba_s
sampans112411003sampans
sandals82715203sandals
sandbags1296373sandbags
sandbank1544863sandbank
sandbanks1644203sandbanks
sandbars11108783sandbars
sangars83116253sangars
sangas75222653sanga_s
sanjaks1834963sanjaks
sansars73313913sansars
sarans64224433sa_rans
suntans72111733suntans
swanpans1343423swanpans
tabuns8489223ta_buns
taipans9269553taipans
tambacs13219363tambacs
tambaks15218153tambaks
tampans113310983tampans
tanbark1337373tanbark
tanbarks1445563tanbarks
tankas104613763tanka_s
tannins72813223tannins
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
turbans939563turbans
unban72114333_unban_
unbars82113033_unbars
unmans82211993_unmans
vandals113211663vandals
vandas103915993vanda_s
vanman1139793vanman_
wangan10311223wangan_
wanguns1135023wanguns
wanigans1244743wanigans
wanions104011373wanions
wantons103713013wantons
xanthans1845693xanthans
zanana153810363zan_ana
zananas16319563zan_anas
zanzas1487053zanza_s

Search took 9 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272608.11016526.1
3Display Results2602600.0932795.7
 (SQL Overall)1786912608.35621384.8
 
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.