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

97 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
attaining104722(None) 
attainting1144781attainting
abstaining1344572abstaining
attaching1545432attaching
attacking1635322attacking
attiring939482att_iring
attorning1045502attorning
attriting1048692attriting
attuning935902att_uning
captaining1546072captaining
detaining112510472detaining
obtaining1236772obtaining
reattaining1244592reattaining
retaining102114732retaining
staining9413372_staining
straining10410562straining
training93015862_training
adjoining1844033adjoining
agatizing2087473agatizing
alining81917043a__lining
antiaging1149673antiaging
antiking13412073ant_iking
arraigning1242783arraigning
assailing1036023assailing
astringing1245773astringing
atomising1247993atomising
atomizing2148513atomizing
atoning83514873a_t_oning
attain6311753atta__in_
attainder10103393attainder
attained997353attain_ed
attainer8116913attain_er
attainers9115593attainers
attainment1255013attainment
attains7310983atta__ins
attaint7313473atta__int
attainted1044693attainted
attaints846493attain_ts
attending11136373attending
attesting1036383attesting
atticizing2246323atticizing
attracting1346563attracting
attritting1144763attritting
availing1267283a_vailing
awaiting1238273a_waiting
bargaining1445213bargaining
battening12268863batt_ening
braining113414683_braining
chaining142810783_chaining
containing13410933containing
curtaining1345533curtaining
datelining1244373datelining
destaining1267943destaining
detailing112510413detailing
detraining1267673detraining
distaining1248903distaining
draining103312673_draining
entailing1039393entailing
entraining1147643entraining
entwining1345423entwining
fattening13287833fatt_ening
gaining94015663__gaining
graining102813183_graining
intwining1345883intwining
latticing1246063latt_icing
maintaining1453593maintaining
mutining11310493mut_ining
ordaining1145753ordaining
outgaining1237093outgaining
outlining10310503outlining
paining103920243__paining
patining11312303pat_ining
patterning1346073patterning
pertaining1347993pertaining
plaining113911553_plaining
raining83922693__raining
rattening10288763ratt_ening
rattooning1143953rattooning
regaining112411083regaining
remaining122212793remaining
retailing103214733retailing
retraining11310243retraining
saining83621393__saining
spraining1248153spraining
staning83922243_sta_ning
stationing1145283stationing
sustaining1145883sustaining
tailing82923103__tailing
tainting93613583__tainting
tanning83618253__tanning
tining74927543__t_ining
traiking132511973_traiking
trailing92916093_trailing
trainings10246733_trainings
trining82919213__trining
twining113211443__twining
untwining1346303untwining

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 Filter1786911486410.406440125.6
2DLD Change Limit148641976.57622603.6
3Display Results97970.0462108.7
 (SQL Overall)178691977.02825425.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.