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

87 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
carlings11401585(None) 
callings113613831callings
cardings123812631cardings
carlines103521641carlines
carling103727061carling_
carlins93921911carlin_s
carpings133812381carpings
carvings143810201carvings
catlings113712041catlings
curlings114110381curlings
darlings103710381darlings
marlings113713491marlings
ablings1038742_ablings
armings103811502_armings
birlings11359612birlings
cabling124017552cabling_
cagelings1335412cagelings
calkings15289222calkings
calling103826772calling_
campings154010202campings
cannings113710332cannings
caplins113515992caplin_s
cappings15369492cappings
carbines123617532carbines
carding113922432carding_
carinas93622402car_inas
caring95137992car_ing_
carking144322852carking_
carlin84421822carlin__
carline93923612carlin_e
carmines123617862carmines
caroling113317002caroling_
carping123521082carping_
carting104228282carting_
carving133916772carving_
casings104013512ca_sings
castings113614052castings
catling104819792catling_
catlins93818842catlin_s
caulkings1633352caulkings
cavings134712542ca_vings
ceilings11397992ceilings
clings95716212c__lings
codlings123110102codlings
cordings123011352cordings
cowlings14359782cowlings
cravings14428222cravings
curbings13407312curbings
curling104320182curling_
cyclings1635372cyclings
cymlings1634212cymlings
darings93713652dar_ings
darklings1533982darklings
darling93418362darling_
darnings10378552darnings
eanlings9128472eanlings
earings84517712ear_ings
earnings9419332earnings
earrings9299632earrings
failings123811012failings
farmings14298222farmings
fatlings12359302fatlings
harpings14379772harpings
hurlings12388212hurlings
kartings13418522kartings
mailings113011922mailings
mallings113413092mallings
marblings14225542marblings
markings153410242markings
marlines103818712marlines
marling103322762marling_
marlins93420472marlin_s
palings103915822pa_lings
pargings123410162pargings
parings104219212par_ings
parkings153610682parkings
parling103823762parling_
partings113513732partings
purlings113910282purlings
railings93412152railings
sailings93513252sailings
saplings11269802saplings
sparlings12257152sparlings
starlings10237922starlings
tailings93211672tailings
warnings12358452warnings
yearlings1384202yearlings

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 Filter1786911210590.390458182.1
2DLD Change Limit121059873.39335679.0
3Display Results87870.0461891.3
 (SQL Overall)178691873.82946667.8
 
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.