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

62 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
actings10451246(None) 
acting95920981acting_
actins86321101actin_s
antings85015581antings
ablings1038742ablings
acetins9313172acetin_s
aching126521972aching_
acing87429152ac_ing_
acinus8311252ac_inus
actin74922552actin__
actinal9312292actinal
actinia91710852actinia
actinias101810842actinias
actinic111810552actinic
actinism12119882actinism
actinon9459462actinon
actinons10389452actinons
actions94218512actions
actives12311522actives
ageings9437692ageings
agings86312672a_gings
airings83913842airings
anting75827022anting_
archings14499862archings
armings103811502armings
askings12519172askings
audings9289392audings
awnings11406712awnings
backings174012212backings
bastings114214692bastings
battings114010572battings
casings104013512casings
castings113614052castings
catlings113712042catlings
cavings134712542cavings
clings95716212_clings
ductings12346672ductings
eastings93412952eastings
eatings84616442eatings
facings134511262fac_ings
fastings124011942fastings
gatings95212822gatings
icings9428452ic_ings
kartings13418522kartings
lacings105013652lac_ings
lastings94214422lastings
lutings83311052lutings
matings104516212matings
mattings11369672mattings
outings84014752outings
packings174310062packings
partings113513732partings
racings105015132rac_ings
ratings84217412ratings
sackings15389632sackings
sacrings11278922sacrings
saltings92811252saltings
stings76220182_stings
tattings9408822tattings
tings65329202__tings
waitings123413742waitings
yachtings1842662yachtings

Search took 9 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.440406115.9
2DLD Change Limit107671627.25014851.2
3Display Results62620.0163875.0
 (SQL Overall)178691627.70623188.6
 
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.