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

55 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
sugarless104367(None) 
scarless10189052s_carless
starless81610842s_tarless
sugarers936302sugar_ers
sugariest1038142sugariest
angerless1045023angerless
barless94317003__barless
carless95118493__carless
earless74316073__earless
fearless1137873_fearless
furless103210143fu__rless
gapless10349993__gapless
garbless11388253__garbless
gasless8319013__gasless
gearless937373_gearless
humorless1442963humorless
oarless73913373__oarless
pugarees11195493pugar_ees
regardless1252893regardless
sapless93313443s__apless
savorless1243213savorless
scarlets10178573s_carlets
seamless10238723s_eamless
seatless83213003s_eatless
sewerless1244303sewerless
shearlegs1342493shearlegs
sighless1276553sig_hless
sightless1385923sightless
snapless10287463s_napless
snarlers8298753s_narlers
soapless10278073s_oapless
sodaless936113soda_less
spanless10247363s_panless
stairless9185623stairless
starlets81610083s_tarlets
strapless1135793strapless
subareas1038633subar_eas
suckless14288823su_ckless
sudaries9312753sudarie_s
sudsless944353su_dsless
sugarbush1551583sugarbush
sugared938583sugar_e_d
sugarer837323sugar_e_r
sugarier937393sugarie_r
sugarlike1443243sugarlike
sugarloaf1351783sugarloaf
sugarplums1561233sugarplums
sugars7312423sugar___s
sumless92611123su__mless
sundress936983sundr_ess
sunless73013693su__nless
suppress1236443suppr_ess
tearless848713_tearless
tugless837383tug__less
warless104015103__warless

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 Filter1786911486410.453394461.4
2DLD Change Limit148641557.15620771.5
3Display Results55550.0331666.7
 (SQL Overall)178691557.64223382.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.