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 “dubbins” 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
dubbins1235880(None) 
dobbins12379531dobbins
dubbin11329251dubbin_
dubbing133311211dubbing
dubbings14245471dubbings
nubbins11268021nubbins
bobbins103410342bobbins
bubbies103913512bubbies
cubbies133312882cubbies
dabbing133511232dabbing
dibbing133110882dibbing
dobbies124113062dobbies
dobbin11339512dobbin_
drubbing14286052drubbing
drubbings15262882drubbings
dubbers124011822dubbers
dumbing13319842dumbing
dunlins849552dunlins
dustbins1144592dustbins
fubbing15409572fubbing
hubbies143211562hubbies
nubbin10308282nubbin_
rabbins112811342rabbins
robbins112811062robbins
rubbies114114112rubbies
rubbing123412272rubbing
rubbings13306332rubbings
subbing123915582subbing
subbings13238482subbings
tubbing123510092tubbing
ablins8316193_ablins
aiblins9311473aiblins
auburns935573auburns
auxins13129813au_xins
bibbing11299603bibbing
bins66548243___bins
blubbing12257013blubbing
bobbies103714563bobbies
bobbin93410723bobbin_
bobbing113113193bobbing
brins75533973__brins
bubbas94110703bubb_as
bubbles104315963bubbles
bubblies1166773bubblies
bubbling12248223bubbling
bulbils11338333bulbils
bumkins15318013bumkins
burins84221893bu_rins
busbies113011693busbies
buskins133310943buskins
cabbies133115163cabbies
cabbing143613153cabbing
cabins104418913_cabins
clubbing15266513clubbing
cubbish1635803cubbish
cubics123810153cu_bics
cubing114213943cu_bing
cubits103714023cu_bits
cuboids1236723cuboids
cumbias13338953cumbias
cumins103314933cu_mins
cummins1358963cummins
curbing123814023curbing
curbings13407313curbings
cutins83919983cu_tins
dabbers123813213dabbers
dabbles124514773dabbles
dabbling14227973dabbling
dabblings15193883dabblings
darbies104216983darbies
daubing11358623daubing
daubries1136743daubries
dauphins1444523dauphins
debits94214493d_ebits
debris93311493debri_s
dentins83419223dentins
derbies103016053derbies
detains83716093detains
deveins1138803deveins
dhobis1236103dhobi_s
diamins10312203diamins
diazins1739183diazins
dibbers124013173dibbers
dibbles124013333dibbles
dibbling14247333dibbling
dibbuks1643163dibbuks
dins56652043d___ins
dioxins1568003dioxins
djins1368453d__jins
dobbers123513243dobbers
dobies94422083d_obies
doblons1037043doblons
dobsons1036203dobsons
domains10510873domains
doobies103915673doobies
dormins10311273dormins
doubling1238153doubling
doubting1237373doubting
drabbing14286803drabbing
drains73719403d_rains
dribbing14325883dribbing
drubbers13386023drubbers
drumlins1144993drumlins
dubbed124113213dubb_ed
dubber113814553dubb_er
dubious1036883dubious
dubnium1244183dubnium
dubniums1343153dubniums
dubs78432193du_b__s
duchies133312313duchies
duckies143613813duckies
ducking154315053ducking
duckpins1743693duckpins
ducting113713593ducting
ductings12346673ductings
dudeens934863dudeens
duding93913323du_ding
dueling93614543dueling
dueting93814393dueting
duits65021883du__its
duking124715133du_king
dulias71212743du_lias
dulling93418273dulling
dumbos114111083dumb_os
dumbs105915753dumb__s
dummies123012133dummies
dumping133712913dumping
dumpings14295763dumpings
dunging103012623dunging
dunking133813263dunking
dunlin739723dunlin_
dunning93514473dunning
duns55140433du___ns
dunting93418383dunting
duping104113633du_ping
dupping133711043dupping
durbars1077973durbars
durians839573durians
during84419403du_ring
durions839963durions
durning93511733durning
durns64819863du__rns
durries83817353durries
dusking133912053dusking
dustbin1044543dustbin_
dusting93618993dusting
dustings10419033dustings
duties74921903du_ties
dybbuks1941603dybbuks
dyneins1134213dyneins
ebbing1137063_ebbing
fibbing15339453fibbing
fibrins1238633fibrins
flubbing16275883flubbing
fobbing153410273fobbing
fusains1038363fusains
gabbing133512033gabbing
gibbing13339363gibbing
gibbons1234973gibbons
globins10278953globins
gobbing132910703gobbing
goblins1039243goblins
grubbing14295403grubbing
guanins8810013guanins
hobbies143813343hobbies
hobbing152811123hobbing
hobbits14317553hobbits
hubbubs1342603hubbubs
hubris11218973hubri_s
jabbing19319413jabbing
jibbing19338053jibbing
jobbing19279013jobbing
jubbahs2143623jubbahs
kebbies1537253kebbies
kibbis14398463kibbi_s
lobbies113612463lobbies
lobbing123110913lobbing
lubbers113913723lubbers
lubing94114033lu_bing
lupins84514463lu_pins
luteins7310103luteins
mobbing14299703mobbing
mucins102712513mu_cins
muffins15308343muffins
muggins11248073muggins
muntins92715133muntins
mureins9310733mureins
muslins9312213muslins
nabbing12299963nabbing
nibbing12339543nibbing
nubbier11308133nubbier
nubbiest12117303nubbiest
nubbiness1334173nubbiness
nubbles113412433nubbles
nubias8310083nu_bias
numbing12269023numbing
ouabains1044363ouabains
outbids1098913outbids
outsins73417863outsins
pubis94616463pu_bi_s
publics13207143publics
puffins15278913puffins
punkins133111113punkins
purins83722653pu_rins
purlins93415423purlins
qubits173710343qu_bits
quinins162811293quinins
quins144819853qu__ins
quoins154110583qu_oins
rabbies113416053rabbies
rabbin103112293rabbin_
rabbis102613153rabbi_s
rabbits11299863rabbits
redubbing1543573redubbing
ribbing123111943ribbing
ribbings13275923ribbings
ribbons1136243ribbons
robbin103611173robbin_
robbing123313213robbing
robins83617443_robins
rubbers113913183rubbers
rubbish1436303rubbish
rubbles113715113rubbles
rubbling13238073rubbling
rubies84420333ru_bies
rubrics1177093rubrics
rubying13297933rubying
rugbies10339353rugbies
ruins55822033ru__ins
rutins63818393ru_tins
sabbing123314743sabbing
sabins85521973_sabins
slubbing13248033slubbing
slubbings14213383slubbings
snubbing13236673snubbing
sobbing127612883sobbing
stubbing13237453stubbing
subbasins1344763subbasins
subbass1138033subbass
suberins10315093suberins
subjoins1745453subjoins
subline9316893subline
sublines10315783sublines
submiss1138083submiss
submits1139743submits
suborns939483suborns
subring104116263subring
subrings11229883subrings
tabbies112913503tabbies
tabbing123611913tabbing
tabbis102910853tabbi_s
tubbers113411243tubbers
tubbier11237743tubbier
tubbiest12117293tubbiest
tubbiness1334423tubbiness
tubing93813083tu_bing
tubings10336483tu_bings
tubulins10106293tubulins
turbans939563turbans
turbine9310303turbine
turbines1039903turbines
turbits969233turbits
unbans81912623_unbans
unbind93011423_unbind
unbinds10267353_unbinds
unpins82312383_unpins
upbind11246303_upbind
upbinds12234813_upbinds
urbias839083_urbias
webbing1536123webbing
webbings1633243webbings
yabbies14279643yabbies

Search took 7 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 Limit1340272726.56320421.6
3Display Results2722720.1102472.7
 (SQL Overall)1786912726.82626178.0
 
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.