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

184 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
gabbro1111495(None) 
gabbros12124651gabbros
gabbard1336552gabbard
gabbart1248882gabbart
gabbed125216892gabbed
gabber114916602gabber
gabbers124612832gabbers
gabble113815722gabble
gabbroic1541992gabbroic
gabbroid1452762gabbroid
gabby135512942gabb_y
abba810522643_abb_a
abbas95918643_abbas
abbe87627183_abb_e
abbes96723523_abbes
abbey125714933_abbey
abbot9318453_abbot
abhor10411063_abhor
abmho1236793_abmho
abo59045963_a_b_o
abort76133583_abort
abri65522213_a_bri
aero45435343_a_ero
aggro738003_aggro
ambo88225133_amb_o
ambry123512093_ambry
andro6314163_andro
arbor74818113_arbor
babble94017113babble
baboo94319503ba_boo
bamboo12310013bamboo
biro66131203__biro
bro56236603___bro
cabbed135416263cabbed
cabbie122913343cabbie
cabby145314553cabb_y
caber95126833caber_
cabers105023903cabers
carbo94923843carb_o
dabbed124416143dabbed
dabber114816963dabber
dabbers123813213dabbers
dabble114515193dabble
daubry12445483daubry
dobro84412213_dobro
fabber134814113fabber
faro76136923fa__ro
gab67155993ga_b__
gabbards1445753gabbards
gabbarts1344063gabbarts
gabbier12379633gabbier
gabbing133512033gabbing
gabbled134112453gabbled
gabbler124013303gabbler
gabblers134110083gabblers
gabbles124415413gabbles
gabies93820723gabies
gabion93211023gabion
gable85325523ga_ble
gabled105518453gabled
gables94222333gables
gaboon93211773gaboon
gabs76740423ga_b_s
gaby107123193ga_b_y
gadjo1436913ga_djo
gager74726293gager_
gagers84021323gagers
galago838903galago
galere73716673galere
galore73514843galore
gamb96331843gamb__
gamba106018513gamb_a
gambado1344973gambado
gambas115817513gambas
gambe106219213gamb_e
gambes116318313gambes
gambia115912233gambia
gambir11509753gambir
gambirs12359073gambirs
gambit114714193gambit
gamble115417183gamble
gambol1138223gambol
gambrel1235453gambrel
gambs105721123gamb_s
gamer84928943gamer_
gamers94420823gamers
gantry103810113gantry
gaper86125123gaper_
gapers94520463gapers
gar47259903ga__r_
garb75332673ga__rb
garbed104815663garbed
garble94118453garble
garbs86321413garb_s
garron73113493ga_rron
gars55750743ga__rs
gasbag1035413gasbag
gater64533643gater_
gaters74728633gaters
gator64416033gator_
gators74115823gators
gaucho1256223gaucho
gaur56723353ga_ur_
gaurs66317993ga_urs
gayer94519193gayer_
gazabo1834833gazabo
gazar154612983gazar_
gazars164811553gazars
gazebo1833673gazebo
gazer155720073gazer_
gazers164516293gazers
gazoo153112873ga_zoo
genro64914033g_enro
gibbed124512353gibbed
gibber114112863gibber
gibbers124710983gibbers
gibbet114113383gibbet
gibbon1135323gibbon
giber85417703giber_
gibers95114663gibers
giro55828633g__iro
gobbed124613883gobbed
gobbet114214443gobbet
gobble113512983gobble
gobo76126893g_ob_o
gombo105814043gomb_o
grabbed13368643grabbed
grabber12389763grabber
grabbers13337883grabbers
grabble12339643grabble
grabby14336183grabb_y
guiro63712093g_uiro
gumbo104413583gumb_o
gyro85217883g__yro
harbor11410723harbor
jabbed184213483jabbed
jabber173713643jabber
jabbers183610583jabbers
jabiru15125503jabiru
kabar114815553kabar_
kabars124513953kabars
labara83712893labara
labor75117313labor_
labors84016403labors
labra75415463la_bra
macro94718173ma_cro
maduro936973maduro
mambo115215733mamb_o
nabbed115113613nabbed
nabber104913543nabber
nabbers113710463nabbers
rabato83413263rabato
rabbet103818653rabbet
rabbi93113173rabb_i
rabbin103112293rabbin
rabbis102613153rabbis
rabbit102914553rabbit
rabble103818243rabble
sabbat10314713sabbat
sabbed114518083sabbed
saber75330243saber_
sabers85224733sabers
sabir75916993sabir_
sabirs85414623sabirs
sabra75317853sa_bra
sabre74821503sa_bre
sambo95118013samb_o
tabard9313333tabard
tabbed114215363tabbed
tabbis102910853tabbis
tabby125213883tabb_y
taber73825823taber_
tabers84621573tabers
taboo73418093ta_boo
tabor75518393tabor_
tabors84517093tabors
taro46846913ta__ro
wabble133714843wabble
wabbly16348363wabbly
yabber136111833yabber
yabbers14389353yabbers
yabbie13308653yabbie
yabby15389743yabb_y
yobbo1237863yobb_o

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161846.70316815.8
3Display Results1841840.0931978.5
 (SQL Overall)1786911846.93925751.7
 
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.