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 “babbitts” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
babbitts114402(None) 
babbitt1038031babbitt_
babbitry14273072babbitry
babbitted1342952babbitted
babbittry1551582babbittry
rabbits11299862rabbi_ts
abbots1039283_abb_ots
abwatts1233403_abwatts
albites9313203_albites
ambits103713413_ambi_ts
babbitries1343193babbitries
babbitting1443003babbitting
babbittries1451643babbittries
babblers113510353babblers
babbles104416323babb_les
babblings13194373babblings
babies106123653ba_bi_es
babiest114414753ba_biest
babysits15143543babysits
backbites19108633backbites
baits76630583ba__i_ts
bambinos1443873bambinos
banditos11347633banditos
bandits103814793bandi_ts
banditti1143873banditti
bankits133410153banki_ts
baptists1236723baptists
barbets114915843barb_ets
barbette1249113barbette
barbettes1348163barbettes
barbies114519593barbi_es
barbital1247053barbital
barbitals1345253barbitals
barbuts11439843barb_uts
barites94322333ba_rites
bassetts10407373bassetts
bassists1037183bassists
batts76727563ba___tts
bauxites1735153bauxites
biblists1236873biblists
bitts75022593___bitts
bobbies103714563bobbi_es
bobbinets1243073bobbinets
bobbins103410343bobbi_ns
britts84813443__britts
bubbies103913513bubbi_es
cabbies133115163cabbi_es
cambists1437023cambists
gabbarts1344063gabbarts
gabbiest1337273gabbiest
gambits12399723gambi_ts
habitats1346733ha_bitats
habits113014653ha_bi_ts
habitus12338173ha_bitus
hobbits14317553hobbi_ts
rabbets11279423rabb_ets
rabbies113416053rabbi_es
rabbins112811343rabbi_ns
rabbis102613163rabbi__s
rabbit102914563rabbi_t_
rabbited1334763rabbited
rabbiter1234673rabbiter
rabbiters1343733rabbiters
rabbitry15243383rabbitry
rabbity14266303rabbi_ty
sabbaths1543973sabbaths
sabbats1138633sabb_ats
tabbies112913503tabbi_es
tabbis102910863tabbi__s
tabbises12236523tabbises
yabbies14279643yabbi_es

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 Filter1786911461620.436409841.7
2DLD Change Limit146162717.07620656.0
3Display Results71710.0332151.5
 (SQL Overall)178691717.54523683.4
 
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.