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

90 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
clivers12341175(None) 
clavers124314901clavers
clovers125114661clovers
livers94927821_livers
slivers104115251slivers
aivers94822322_aivers
aliners74717722aliners
calibers1238522calibers
calipers1249442calipers
carvers124817532carvers
cavers115026842c_avers
ceilers93912532ceilers
chiders135312942chiders
chimers144515142chimers
chives144317592chive_s
ciders94620092c_iders
citers85022982c_iters
civets115212542c_ivets
claimers12298742claimers
claver113816972claver_
claves115020062clave_s
claviers1367102claviers
clawers123910972clawers
cleavers13398872cleavers
clever114611532clever_
clickers163910202clickers
climbers14318412climbers
climes104720002clime_s
clines84926042cline_s
clingers113810662clingers
clinkers14339832clinkers
clippers14368842clippers
clivias1266692clivias
cloners94514822cloners
closers94415322closers
clover114617122clover_
clovery15407402clovery
cloves114918822clove_s
coilers93619902coilers
coiners93620752coiners
covers114627962c_overs
cravers124416552cravers
criers83918582cri_ers
culvers12329832culvers
delivers123310752delivers
divers105024962_divers
drivers114412792drivers
elvers93814982el_vers
fivers124420922_fivers
fliers94417192fli_ers
flivvers1733112flivvers
givers104817712_givers
gliders94811842gliders
glovers114310882glovers
jivers164515642_jivers
lavers94526362_lavers
levers94621322_levers
libers84721442_libers
liers55130402_li_ers
lifers95617842_lifers
ligers75022042_ligers
likers104620912_likers
liners65428852_liners
liters65429882_liters
livens94314892_livens
liver85132962_liver_
livery124910902_livery
lives86133192_live_s
liviers104211072_liviers
livres94311862_livres
livyers13365902_livyers
lovers94223432_lovers
olives94313952olive_s
pliers84715152pli_ers
plovers123611832plovers
quivers19298752quivers
reivers105117082reivers
rivers94626542_rivers
shivers133714832shivers
silvers104714042silvers
sivers95324152_sivers
skivers14409702skivers
slavers103716502slavers
slicers94114922slicers
sliders83515222sliders
sliver94116592sliver_
stivers103613542stivers
vivers124717362_vivers
waivers133410052waivers
wivers125320802_wivers

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 Filter1786911076710.356501941.0
2DLD Change Limit107671902.83038046.3
3Display Results90900.0303000.0
 (SQL Overall)178691903.21655563.1
 
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.