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

109 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
babbitt103803(None) 
babbitts1144021babbitts
babbitry14273072babbitry
babbitted1342952babbitted
babbittry1551582babbittry
rabbit102914552rabbi_t
rabbits11299862rabbits
rabbity14266302rabbity
abbot9318453_abb_ot
abbots1039283_abbots
abwatt11410673_abwatt
albite8313303_albite
ambit94223693_ambi_t
ambits103713393_ambits
babbitting1443003babbitting
babble94017113babb_le
babbled113612863babbled
babbler104012823babbler
babbles104416323babbles
babbling12228693babbling
babied114913503ba_bied
babier103515563ba_bier
babies106123643ba_bies
babiest114414753babiest
babying1537963babying
babyish1736513babyish
babysat14135233babysat
babysit14145613babysit
babysits15143543babysits
backbit17129103backbi_t
backbite1899173backbite
bait66556003ba__i_t
baith108023133ba__ith
baits76630583ba__its
bambini1336573bambini
bambino1336473bambino
bandit93821133bandi_t
bandito103710043bandito
bandits103814793bandits
banditti1143873banditti
bankit123617043banki_t
bankits133410153bankits
baptist11311873baptist
barbate11314543barbate
barbet104427883barb_et
barbets114915843barbets
barbette1249113barbette
barbie105018353barbi_e
barbies114519593barbies
barbing123716993barbing
barbital1247053barbital
barbut104617003barb_ut
barbuts11439843barbuts
barite84224813ba_rite
bassett94213863bassett
bassist9312743bassist
batt65053873ba___tt
bauxite1635573bauxite
bibbing11299603bibbing
biblist11310833biblist
bitt65545803___bitt
blabbing12266723blabbing
bobbies103714563bobbies
bobbin93410723bobbi_n
bobbinet1157903bobbinet
bobbing113113193bobbing
bobbins103410343bobbins
britt75732233__britt
bubbies103913513bubbies
cabbie122913343cabbi_e
cabbies133115163cabbies
cabbing143613153cabbing
cambist13312103cambist
dabbing133511233dabbing
fabbest1438033fabbest
gabbart1248883gabbart
gabbier12379633gabbier
gabbiest1337273gabbiest
gabbing133512033gabbing
gambit114714193gambi_t
gambits12399713gambits
habit103027013ha_bi_t
habitat12411053ha_bitat
habits113014643ha_bits
hobbit132810523hobbi_t
hobbits14317553hobbits
jabbing19319413jabbing
kibbitz2443943kibbitz
nabbing12299963nabbing
rabbet103818653rabb_et
rabbets11279423rabbets
rabbi93113173rabbi__
rabbies113416053rabbies
rabbin103112293rabbi_n
rabbins112811343rabbins
rabbis102613153rabbi_s
rabbited1334763rabbited
rabbiter1234673rabbiter
rabbitry15243383rabbitry
sabbat10314713sabb_at
sabbath1445393sabbath
sabbats1138633sabbats
sabbing123314743sabbing
tabbied12297793tabbied
tabbies112913503tabbies
tabbing123611913tabbing
tabbis102910853tabbi_s
yabbie13308653yabbi_e
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 Limit1340271096.22021547.7
3Display Results1091090.0303633.3
 (SQL Overall)1786911096.40327907.4
 
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.