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

98 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
bobberies1210789(None) 
bibberies1297131bibberies
jobberies20115421jobberies
robberies13107391robberies
bobbers103614282bobber__s
bobbies103714562bobb__ies
boiseries11411042boiseries
booteries11312772booteries
boweries13312292bo_weries
boxberries2143802boxberries
briberies1348332briberies
snobberies1444082snobberies
amberies122514683_amberies
babbitries1343193babbitries
bakeries14312193b_akeries
barberries1446233barberries
batteries11615113batteries
bayberries1744093bayberries
beaneries11310903beaneries
bebeerines1454023bebeerines
berberines1445633berberines
berberins1346713berberins
berberis1246603berberi_s
berberises1444903berberises
bibbers103911353bibber__s
bilberries1444943bilberries
binderies12311683binderies
bloomeries1446103bloomeries
bobber95016743bobber___
bobbery13438353bobber__y
bobbins103410343bobb__ins
bobbles104514913bobb__les
bobeches1744483bo_beches
boiserie1047993boiserie_
bombers134512593bomber__s
bombesins1543783bombesins
boobies113718203boob__ies
botcheries1746053botcheries
braveries1439103braveries
breweries1447583breweries
brogueries1344813brogueries
broideries1346353broideries
bubbies103913513bubb__ies
bubblies1166773bubb_lies
buggeries1347083buggeries
butleries11710073butleries
butteries11711763butteries
cobbers134114753cobber__s
congeries12316403congeries
cookeries151210633cookeries
cooperies131113313cooperies
coteries10422703co_teries
cowberries1744623cowberries
dauberies1248033dauberies
dobbers123513253dobber__s
dobbies124113063dobb__ies
dodgeries1246593dodgeries
dogberries1443863dogberries
doggeries1246673doggeries
doweries12411933do_weries
fooleries1248743fooleries
fopperies1666013fopperies
forgeries13310003forgeries
hobbers143512343hobber__s
hobbies143813343hobb__ies
hosieries1249213hosieries
jobbers182911133jobber__s
joineries1648103joineries
lobbers113713943lobber__s
lobbies113612463lobb__ies
lotteries9311073lotteries
mobbers133610923mobber__s
mockeries17128263mockeries
monkeries15129913monkeries
moperies12313873mo_peries
naboberies1443263naboberies
observes1346173_observes
obverses1335803_obverses
orreries8310123_orreries
poperies12316793po_peries
potteries11313593potteries
robbers112814163robber__s
robotries1147323robotries
rockeries15128973rockeries
rogueries1047003rogueries
rookeries13138173rookeries
roperies10315763ro_peries
roseries8317313ro_series
rubberier1344393rubberier
rubberiest1444393rubberiest
rubberizes23133823rubberizes
sobbers114114263sobber__s
soberizes2098963so_berizes
sorceries1149933sorceries
subseries11312933subseries
toggeries1146213toggeries
voleries11313233vo_leries
wobblies15297233wobb_lies

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 Filter1786911486410.423422437.4
2DLD Change Limit148641986.09324395.4
3Display Results98980.0462130.4
 (SQL Overall)178691986.56227231.2
 
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.