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

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
libels8511269(None) 
labels84515681labels
libel74116101libel_
libers84721431libers
babels105216722babels
bels66142492__bels
bibles104617642bibles
cibols1039522cibols
fibers114717522fibers
gibers95114662gibers
gibes84422522gibe_s
gimels938892gimels
jebels15418912jebels
jibers155912882jibers
jibes145520322jibe_s
kibeis12469802kibeis
kibes115521112kibe_s
label75019382label_
lapels83712042lapels
lebens8310092lebens
levels94113282levels
libbers113812822libbers
libeled10249412libeled
libelee92510982libelee
libelees10227212libelees
libeler9219002libeler
libelers10238622libelers
libelist10310822libelist
libelous1047192libelous
liber74723612libe_r
liberals1039412liberals
libras83711702libras
libs66732752lib__s
liens56525502li_ens
liers55130402li_ers
lies46454192li_e_s
lieus56218482li_eus
lifers95617842lifers
ligers75022022ligers
likely13328132likely
likens105613702likens
likers104620912likers
likes96231902like_s
limbers113614722limbers
limens84618032limens
limes75636502lime_s
limeys11429272limeys
linens64818392linens
liners65428842liners
lines57054572line_s
lintels73311162lintels
lisles63416282lisles
listels74212432listels
liters65429872liters
lively123310812lively
livens94314892livens
livers94927822livers
lives86133192live_s
lobes75331002lobe_s
losels64714582losels
lubes74727992lube_s
pibals103813082pibals
pixels15478532pixels
rebels84518132rebels
ribes75530172ribe_s
riels55121332ri_els
rubels84112992rubels
sibyls1135302sibyls
umbels104510582umbels
vibes104719952vibe_s
zibets1737742zibets

Search took 4 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 Filter178691825510.186960704.3
2DLD Change Limit82551712.90628407.1
3Display Results71710.0302366.7
 (SQL Overall)178691713.12257236.1
 
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.