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

72 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
cardings12381263(None) 
carding113922431carding_
carlings114015851carlings
carpings133812381carpings
carvings143810201carvings
cordings123011351cordings
armings103811502_armings
audings9289392_audings
barding113822892barding_
birdings12378822birdings
boardings13296062boardings
calkings15289222calkings
callings113613832callings
campings154010202campings
cannings113710332cannings
cappings15369492cappings
carbines123617532carbines
cardiacs1376912cardiacs
cardias10715112cardi_as
cardinal1139562cardinal
cardinals1247992cardinals
carditis11310222carditis
cardons104519932cardon_s
carinas93622402car_inas
caring95137992car_ing_
carking144322852carking_
carlines103521642carlines
carling103727062carling_
carlins93921912carlin_s
carmines123617862carmines
carping123521082carping_
carting104228282carting_
carving133916772carving_
casings104013512ca_sings
castings113614052castings
catlings113712042catlings
cavings134712542ca_vings
claddings1433212claddings
cording113620822cording_
cravings14428222cravings
curbings13407312curbings
curding113515132curding_
curlings114110382curlings
darings93713652dar_ings
darlings103710382darlings
darnings10378552darnings
earings84517712ear_ings
earnings9419332earnings
earrings9299632earrings
fadings12469302fa_dings
farding123716742farding_
farmings14298222farmings
harpings14379772harpings
hoardings14315112hoardings
kartings13418522kartings
ladings93814132la_dings
landings103110072landings
larding92917872larding_
lordings10368502lordings
markings153410242markings
marlings113713492marlings
paddings13297012paddings
pargings123410162pargings
parings104219212par_ings
parkings153610682parkings
partings113513732partings
sardines92815562sardines
waddings14356472waddings
warding123918142warding_
warnings12358452warnings
wordings13328562wordings
yarding123413142yarding_

Search took 5 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 Filter1786911210590.1561145455.1
2DLD Change Limit121059724.34327874.5
3Display Results72720.0302400.0
 (SQL Overall)178691724.52939454.8
 
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.