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

140 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
gabbros1212465(None) 
gabbro11114951gabbro_
gabbards1445752gabbards
gabbarts1344062gabbarts
gabbers124612832gabbers
gabbles124415412gabbles
gabbroic1541992gabbroic
gabbroid1452762gabbroid
abbas95918643_abb_as
abbes96723523_abb_es
abbess10509773_abbess
abbeys13538423_abbeys
abbot9318453_abb_ot
abbots1039283_abbots
abhors11410623_abhors
abmhos1334973_abmhos
aborts84916183_aborts
abos67734413_a_b_os
abris75722603_a_bris
aggros836553_aggros
ambos95321253_amb_os
andros7313303_andros
arbors84717883_arbors
babbles104416323babbles
baboos103517013ba_boos
bamboos1348753bamboos
biros75325133__biros
bros65635663___bros
cabbies133115163cabbies
cabers105023923caber_s
carbos105122263carb_os
dabbers123813213dabbers
dabbles124514773dabbles
dobros93910233_dobros
faros85532023fa__ros
gabbard1336553gabbard
gabbart1248883gabbart
gabbed125216893gabb_ed
gabber114916603gabb_er
gabbier12379633gabbier
gabbiest1337273gabbiest
gabbing133512033gabbing
gabble113815723gabb_le
gabbled134112453gabbled
gabbler124013303gabbler
gabblers134110083gabblers
gabby135512953gabb__y
gabies93820733ga_bies
gabion93211033ga_bion
gabions102410053gabions
gables94222333ga_bles
gaboon93211773ga_boon
gaboons10289903gaboons
gabs76740423ga_b__s
gagers84021333gager_s
galagos938153galagos
galeres83514343galeres
galores82614343galores
gambados1444153gambados
gambas115817513gamb_as
gambes116318313gamb_es
gambias125010733gambias
gambirs12359083gambirs
gambits12399723gambits
gambles124016203gambles
gambol1138223gamb_ol
gambols1238593gambols
gambrel1235453gambrel
gambrels1334213gambrels
gambs105721123gamb__s
gamers94420833gamer_s
gapers94520473gaper_s
garbles104016923garbles
garbs86321413ga__rbs
garron73113493ga_rron
garrons82713463ga_rrons
gars55750743ga__r_s
gasbags1135473gasbags
gaters74728643gater_s
gators74115843gator_s
gauchos1345903gauchos
gaurs66317993ga_ur_s
gazabos1944453gazabos
gazars164811553gazar_s
gazebos1933493gazebos
gazers164516303gazer_s
gazoos163010223ga_zoos
genros74211333g_enros
gibbers124710983gibbers
gibbets12417723gibbets
gibbon1135323gibb_on
gibbons1234983gibbons
gibbose1244083gibb_ose
gibbous1265333gibbous
gibers95114663giber_s
giros65722653g__iros
glabrous1145533glabrous
gobbets12327643gobbets
gobbles123512583gobbles
gobos86219383g_ob_os
gombos114311093gomb_os
grabbers13337883grabbers
grabbles13339893grabbles
guiros7389093g_uiros
gumbos114610873gumb_os
gyros95616483g__yros
harbors12412413harbors
jabbers183610583jabbers
jabirus1694573jabirus
kabars124513953kabar_s
labors84016413labor_s
macros104017013ma_cros
maduros1036303maduros
mambos125414493mamb_os
nabbers113710463nabbers
rabatos93010903rabatos
rabbets11279423rabbets
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613163rabb_is
rabbits11299863rabbits
rabbles113517973rabbles
sabbats1138633sabbats
sabers85224733saber_s
sabirs85414633sabir_s
sabras85116363sa_bras
sabres85520863sa_bres
sambos104315193samb_os
saros55238063sa__ros
tabards10310383tabards
tabbies112913503tabbies
tabbis102910863tabb_is
tabers84621573taber_s
taboos83815433ta_boos
tabors84517113tabor_s
taros55640823ta__ros
wabbles144013993wabbles
yabbers14389353yabbers
yabbies14279643yabbies
yobbos1335963yobb_os

Search took 8 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.423422437.4
2DLD Change Limit1340271407.15618729.3
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.62523434.9
 
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.