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

93 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
riverless124494(None) 
driverless1452701driverless
riderless1044901riderless
coverless1436802coverless
fiberless1444452fiberless
hiveless14227932hive_less
linerless936332linerless
riverbeds15243072riverbeds
airless73712043ai__rless
angerless1045023angerless
briefless1443623bri_efless
brineless1136263brine_less
cheerless1495293cheerless
coverlets1437053coverlets
crimeless1335063crime_less
dinnerless1152713dinnerless
diverges13258313diverge_s
diverters13227873diverters
dowerless1344013dowerless
drivelers1364223drive_lers
drivellers1452953drivellers
drivenness1443463drivenness
fireless112810593fire_less
governess1346173governess
graveless13226693grave_less
groveless13235363grove_less
hideless12278713hide_less
iceless9219963_ice_less
idealess935653_idealess
inverness1247133inverness
ireless72312243_ire_less
lifeless11228143life_less
limeless10249663lime_less
lineless82711943line_less
liveness112411393live_ness
liveries11314373liverie_s
liverleaf1542103liverleaf
loveless1168573love_less
moveless1367753move_less
orderless1044313orderless
overlets112312363_overlets
paperless1345833paperless
peerless1037513_peerless
pileless1088623pile_less
pipeless12107663pipe_less
powerless1444293powerless
priceless1336893price_less
ravelers113310863rave_lers
ravellers12257173ravellers
revealers12318243revealers
revelers113414133reve_lers
revellers12319513revellers
reverers113113153rever_ers
reveres103621343rever_e_s
reveries112518513reverie_s
reversers12298483reversers
reverses112513513reverse_s
reverters122710433reverters
ribless93410343ri__bless
rifeness1138603rife_ness
riftless1136943ri_ftless
rimless9369363ri__mless
rindless92510203ri_ndless
ripeness1039373ripe_ness
riskless1235763ri_skless
riverbed14245143riverbe_d
riverhead1643003riverhead
riverheads1742753riverheads
riverlike1644483riverlike
rivers94626543river___s
riverweed1643053riverweed
riverweeds1742243riverweeds
riveters11228163rive_ters
rivieres1136013rivier_e_s
rivulets1174753riv_ulets
rudderless1241953rudderless
ruleless836633rule_less
savorless1243213savorless
sewerless1244303sewerless
sinewless1244363sinewless
tideless9269083tide_less
tieless72512563ti_e_less
timeless10239543time_less
tireless82510263tire_less
verbless1336033__verbless
viceless1337983vice_less
viewless1434033vi_ewless
visorless1243143visorless
waterless1238013waterless
waveless1437483wave_less
wifeless14277483wife_less
wineless112711173wine_less
wireless11249633wire_less

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.406440125.6
2DLD Change Limit148641936.97021325.8
3Display Results93930.0462021.7
 (SQL Overall)178691937.42224075.9
 
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.