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 “casings” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
casings10401351(None) 
casing94829101casing_
casinos93512831casinos
castings113614051castings
cavings134712541cavings
chasings14318251chasings
actings104512462actings
agings86312672_agings
askings12519172_askings
bakings144312022bakings
bashings144311242bashings
basing95427662basing_
basins85722762basin_s
bastings114214692bastings
busings103711222busings
cabins104418922cabin_s
caging105321022caging_
cains75334302ca_in_s
caking134624672caking_
calkings15289222calkings
callings113613832callings
campings154010202campings
canines93724032canines
caning94128622caning_
cannings113710332cannings
cappings15369492cappings
cardings123812632cardings
carinas93622402carinas
caring95137992caring_
carlings114015852carlings
carpings133812382carpings
carvings143810202carvings
caseins93115052casein_s
cashing135022552cashing_
casini84615862casin_i
casino84317552casin_o
casitas93312042casitas
casking144317352casking_
cassinas103610632cassinas
cassines103116612cassines
cassinos10309352cassinos
casting104628342casting_
catlings113712042catlings
causing103614412causing_
caving124822612caving_
cawing124322612cawing_
ceasing104118262ceasing_
chasing133715892chasing_
clings95716212c_lings
closings11277672closings
coamings13349292coamings
coastings12357862coastings
coatings113811842coatings
comings124013532comings
copings124111842copings
cosigns1047512cosigns
cosines94122672cosines
covings134511242covings
cravings14428222cravings
darings93713652darings
earings84517712earings
easing74926462easing_
eastings93412952eastings
eatings84616442eatings
facings134511262facings
fadings12469302fadings
fastings124011942fastings
gamings114610912gamings
gaskings14427472gaskings
gassings10438402gassings
gatings95212822gatings
hayings14379392hayings
hazings20378342hazings
lacings105013652lacings
ladings93814132ladings
lakings124713512lakings
lashings124412252lashings
lasing74727982lasing_
lastings94214422lastings
lawings113611472lawings
leasings9379842leasings
losings82810622losings
makings145413162makings
maskings15448752maskings
matings104516212matings
mayings134410512mayings
musings10389542musings
nosings8349592nosings
pagings114411062pagings
palings103915822palings
parings104219212parings
passings11409872passings
pavings134011632pavings
racings105015132racings
raisings9338442raisings
rasing74330832rasing_
raspings11337852raspings
ratings84217412ratings
ravings114614502ravings
risings83211892risings
sasins64923102sasin_s
savings114412952savings
sayings113610832sayings
sings65532702__sings
takings124512572takings
washings15419272washings
waxings18366452waxings

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 Filter1786911076710.453394461.4
2DLD Change Limit1076711076.29617101.5
3Display Results1071070.280382.1
 (SQL Overall)1786911077.02925422.0
 
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.