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

77 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
abseiling126534(None) 
abscising1444942abscising
absenting1236992absenting
assailing1036022assailing
assoiling1045352assoiling
abegging1334483ab_egging
abetting1158293ab_etting
abiding11510503ab__iding
abscessing1543313abscessing
abscisin1243973abscisin_
abscisins1343593abscisins
abseil837183abseil___
abseiled1144733abseil_ed
abseils935973abseil__s
absolving1543323absolving
absorbing1444483absorbing
abstaining1344573abstaining
absterging1453353absterging
abuilding1343563ab_uilding
ailing74331013a___iling
aneling82719503a_ne_ling
angeling102811733ange_ling
annealing1047453annealing
anviling1239743a_nviling
appealing1446493appealing
aspiring1138873a_spiring
assembling1542883assembling
assenting1038163assenting
asserting1038663asserting
assessing1045173assessing
atheling1249203athe_ling
aureoling1045873aureoling
availing1267283a_vailing
bailing103723523_b_ailing
baseline10310753base_line
beetling1139283_beetling
belling103825073_b_elling
besmiling1436263besmiling
boiling103819673_b_oiling
brailing113514793_brailing
broiling113112013_broiling
ceiling103416723__ceiling
ensiling9410723ens_iling
hanseling1338063hanse_ling
hanselling1445623hanselling
heiling113616363__heiling
labeling11311643lab_e_ling
labelling1238083lab_elling
misfiling1537223misfiling
observing1544383observing
obsessing1244263obsessing
resailing103314253resailing
resealing102115673resealing
reseizing19311233reseizing
reselling102213833reselling
resiling93520173res_iling
sailing83927373__sailing
sealing83528563__sealing
seeling83522003__seeling
seining84020773__seining
seising84018863__seising
seizing174114833__seizing
selling83225833__selling
smiling103915443__smiling
soiling83422323__soiling
speiling113612973_speiling
spiling102919703__spiling
subceiling1545193subceiling
subsoiling1344873subsoiling
tasseling1035853tasse_ling
tasselling1145233tasselling
unsealing10711043unsealing
unselling10810333unselling
unsmiling1256873unsmiling
unveiling1337723unveiling
veiling113615293__veiling
wassailing1443593wassailing

Search took 7 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.1531167915.0
2DLD Change Limit148641776.67322275.0
3Display Results77770.0332333.3
 (SQL Overall)178691776.85926052.0
 
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.