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

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

117 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
attainer811691(None) 
attainder10103391attainder
attained997351attained
attainers9115591attainers
abstainer1144402abstainer
attacher13125712attacher
attacker14144982attacker
attain6311752attain__
attainders11112772attainders
attains7310982attain_s
attaint7313472attain_t
attainted1044692attainted
attaints846492attaints
detainer92910792detainer
obtainer1045792obtainer
retainer82913812retainer
stainer73614922_stainer
strainer8512222strainer
trainer73316792_trainer
abstained1245053abstained
abstainers1243453abstainers
actioner1048663actioner
airliner836953airliner
aliner65621983a__liner
antsier7410773antsi_er
arraigner1092973arraigner
artier63419733art_i_er
artsier768943artsi_er
assailer844823assailer
astatine8313533astatine_
astatines9310343astatines
atelier7311623ateli_er
atomiser10268153atomiser
atomizer19298533atomizer
atoner64817193a_t_oner
atrazine1748403atrazine_
atrazines1846683atrazines
attache12106693attache_
attached14165703attached
attachers14134883attachers
attaches13137723attaches
attacked15125113attacked
attackers15144013attackers
attaining1047223attaining
attainment1255013attainment
attar56516693atta___r
attemper12103633attemper
attender935913attender
attester836503attester
attire62412383att_ire_
attired8238913att_ired
attires72312953att_ires
attorned955353attorned
attorney1173723attorney
attracter1146093attracter
attrite7311833attrite_
attrited947373attrited
attrites8311563attrites
attune637983att_une_
attuned835173att_uned
attunes737823att_unes
atwain937813atwain__
awaiter1057443a_waiter
bargainer1244563bargainer
battener10369393batt_ener
battier93515713batt_i_er
betaine9413783betaine_
betaines10313293betaines
captained1446193captained
cattier93317073catt_i_er
certainer1146193certainer
container11311073container
detailer9268673detailer
detained103111643detained
detainee92511723detainee
detainers10269103detainers
drainer83012843_drainer
entailer877833entailer
entrainer968583entrainer
fainer94717243__fainer
fattener11268113fatt_ener
fattier103513463fatt_i_er
gainer74117493__gainer
grainer83714063_grainer
jetliner1534853jetliner
maintainer1243513maintainer
nattier73614623natt_i_er
obtained1136533obtained
obtainers1144853obtainers
ordainer945223ordainer
outliner82412113outliner
plainer93811983_plainer
rattailed1084213rattailed
rattener8238533ratt_ener
rattier74015593ratt_i_er
reattained1144583reattained
regainer9249353regainer
retailer82911573retailer
retained93016093retained
retainers92510763retainers
staider83912613_staider
stained84215343_stained
stainers83212173_stainers
stationer946033stationer
strained9412253strained
strainers9510383strainers
straiter8311783straiter
sustainer944783sustainer
tailer63823733__tailer
tanner63722283__tanner
tattier74216243tatti_er
trailer73015393_trailer
trained84117203_trained
trainee72817793_trainee
trainers83114643_trainers
twiner94012593__twiner
vainer93714573__vainer

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621176.34323043.0
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.81226231.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.