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

272 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
dubbin1132926(None) 
dobbin11339521dobbin
dubbing133311211dubbing
dubbins12358801dubbins
nubbin10308291nubbin
bobbin93410732bobbin
dabbing133511232dabbing
dibbing133110892dibbing
dobbins12379532dobbins
drubbing14286052drubbing
dubbed124113212dubbed
dubber113814552dubber
dubbings14245472dubbings
dumbing13319852dumbing
dunlin739722dunlin
dustbin1044542dustbin
fubbing15409572fubbing
nubbins11268022nubbins
rabbin103112302rabbin
robbin103611182robbin
rubbing123412272rubbing
subbing123915582subbing
tubbing123510092tubbing
auburn836213auburn
auxin121411913au_xin
bibbing11299613bibbing
bin56658643___bin
blin67228173__blin
blubbing12257013blubbing
bobbing113113193bobbing
bobbins103410343bobbins
brin67038193__brin
bubba84311803bubb_a
bubbas94110703bubbas
bubbies103913513bubbies
bubble94016593bubble
bubbling12248223bubbling
bubbly124110353bubbly
bubby115013933bubb_y
bulbil10389573bulbil
bumkin14308083bumkin
burin75626063bu_rin
buskin123811493buskin
cabbie122913353cabbie
cabbing143613153cabbing
cabin94820943_cabin
clubbing15266513clubbing
cubbies133312883cubbies
cubbish1635803cubbish
cubby145212123cubb_y
cubic114313423cu_bic
cubing114213953cu_bing
cubit94122893cu_bit
cuboid1139503cuboid
cumbia12379893cumbia
cumin94616973cu_min
cummin1288783cummin
curbing123814023curbing
cutin75022783cu_tin
dabbed124416143dabbed
dabber114816963dabber
dabble114515193dabble
dabbling14227973dabbling
daubing11358623daubing
dauphin1344383dauphin
debit85727853d_ebit
debris93311493debris
dentin73919573dentin
detain74617383detain
devein1039143devein
dhobi1136973dhobi_
dhobis1236113dhobis
diamin9312523diamin
diazin1639163diazin
dibbed124713473dibbed
dibber114614713dibber
dibble114013843dibble
dibbling14247333dibbling
dibbuk1543503dibbuk
din46459463d___in
dioxin14118783dioxin
djin12911633d__jin
dobber114015423dobber
dobbies124113063dobbies
dobby136013633dobb_y
dobie84920333d_obie
doblon938013doblon
dobson936593dobson
domain9511323domain
doobie94712683doobie
dormin9312313dormin
doubling1238153doubling
doubting1237373doubting
drabbing14286803drabbing
drain65222893d_rain
dribbing14325883dribbing
drubbed13406983drubbed
drubber12357863drubber
drubbings15262883drubbings
drumlin1044423drumlin
dub66642203du_b__
dubbers124011823dubbers
dubnium1244183dubnium
dubs78432193du_b_s
duci76422623du_ci_
duckie133511663duckie
ducking154315053ducking
duckpin1643463duckpin
ducting113713593ducting
duddie9348863duddie
dudeen857173dudeen
duding93913323du_ding
dueling93614543dueling
dueting93814393dueting
dui46433383du__i_
duit56241583du__it
duking124715133du_king
dulia61014983du_lia
dulling93418273dulling
dumb97124103dumb__
dumbed124012083dumbed
dumber114414173dumber
dumbly14399603dumbly
dumbo105614063dumb_o
dumbos114111083dumbos
dumbs105915753dumb_s
dumping133712913dumping
dun46545583du___n
dunging103012623dunging
dunking133813263dunking
dunlins849553dunlins
dunning93514473dunning
dunting93418383dunting
duomi8310133duomi_
duping104113633du_ping
dupping133711043dupping
durbar968723durbar
durian7312003durian
during84419403du_ring
durion7510963durion
durn56127633du__rn
durning93511733durning
durrie73713263durrie
dusking133912053dusking
dustbins1144593dustbins
dusting93618993dusting
dybbuk1841753dybbuk
dynein1035563dynein
ebbing1137073_ebbing
fibbing15339463fibbing
fibrin1138533fibrin
flubbing16275883flubbing
fobbing153410273fobbing
fubbed144711243fubbed
fusain958643fusain
gabbing133512033gabbing
gibbing13339373gibbing
gibbon1135323gibbon
globin9309723globin
gobbing132910703gobbing
goblin939503goblin
grubbing14295403grubbing
guanin7610803guanin
hobbing152811123hobbing
hobbit132810543hobbit
hubbies143211563hubbies
hubbly16478413hubbly
hubbub1243603hubbub
hubby155011403hubb_y
hubris11218973hubris
jabbing19319413jabbing
jibbing19338063jibbing
jobbing19279013jobbing
jubbah2034353jubbah
kebbie1435813kebbie
kibbi13449273kibbi_
kibbis14398473kibbis
lobbing123110913lobbing
lubber104214623lubber
lubing94114043lu_bing
lubric1097983lubric
lupin75215843lu_pin
lutein6311263lutein
mobbing14299703mobbing
mucin93116823mu_cin
muffin14298873muffin
muntin82915183muntin
murein8311763murein
muslin8312213muslin
nabbing12299963nabbing
nibbing12339553nibbing
nubbier11308133nubbier
nubble103813713nubble
nubbly13369673nubbly
nubby125011033nubb_y
nubia7311233nu_bia
numbing12269033numbing
ouabain944943ouabain
outbid91411863outbid
outsin63617563outsin
pubic114513723pu_bic
pubis94616473pu_bis
public12238143public
puffin141149003puffin
punkin123611523punkin
purin75527593pu_rin
purlin83615863purlin
qubit164218993qu_bit
quin135823923qu__in
quinin152811953quinin
quoin144012323qu_oin
rabbi93113183rabbi_
rabbins112811343rabbins
rabbis102613163rabbis
rabbit102914563rabbit
redubbing1543573redubbing
ribbing123111953ribbing
ribbon1036533ribbon
robbing123313213robbing
robbins112811063robbins
robin74820283_robin
rubbed114515083rubbed
rubber104715793rubber
rubbies114114113rubbies
rubbings13306333rubbings
rubbish1436303rubbish
rubble104315673rubble
rubbling13238073rubbling
rubbly133710613rubbly
rubby124413863rubb_y
rubric1097823rubric
rubying13297933rubying
ruin47430513ru__in
rurban849043rurban
rutin55421343ru_tin
sabbing123314743sabbing
sabin74924953_sabin
slubbing13248033slubbing
snubbing13236673snubbing
sobbing127612883sobbing
stubbing13237453stubbing
subbasin1245393subbasin
subbed114116673subbed
subbings13238483subbings
suberin9314563suberin
subfix1835073subfix
subjoin1645443subjoin
subline9316893subline
submit10312673submit
suborn8310013suborn
subring104116263subring
tabbing123611913tabbing
tabbis102910863tabbis
tubbed114712223tubbed
tubber104313203tubber
tubbier11237743tubbier
tubby124511403tubb_y
tubing93813093tu_bing
tubulin9116433tubulin
turban8310483turban
turbid979713turbid
turbine9310303turbine
turbit8715113turbit
unban72114333_unban
unbid83214643_unbid
unbind93011433_unbind
unpin72613243_unpin
upbind11246313_upbind
urban72013863_urban
urbia7311143_urbia
webbing1536123webbing
yabbie13308663yabbie

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162725.44020719.9
3Display Results2722720.0932924.7
 (SQL Overall)1786912725.90630255.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.