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

162 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
variating1331095(None) 
lariating10311791lariating
aviating12311022_aviating
marinating13410272marinating
narrating10310352narrating
patriating13510202patriating
radiating111112132radiating
satiating10311812satiating
seriating10916402seriating
striating10914192striating
vacating14310362va_cating
validating1545842validating
valuating1338652valuating
variation12312392variation
variations13310772variations
variegating1643212variegating
variolating1544942variolating
vitiating1338412vitiating
abating10413973_a_bating
ablating11312003_ablating
aerating92821003_aerating
agisting1038243_agisting
agitating1138863_agitating
airting83616303_a_irting
aliasing9310073_aliasing
animating12312513_animating
arcading1239763_arcading
arising83619973_ari_sing
arointing1049363_arointing
arraying1238753_arraying
awaiting1238273_awaiting
baiting103918883ba_i_ting
barraging1337383barraging
berating113220763ber_ating
borating113414503bor_ating
carpeting1439483carpeting
carting104228283car__ting
caseating12311743caseating
caveating1539293caveating
cavitating1646913cavitating
charioting1645723charioting
crating103725203_cr_ating
creating113921953_creating
curating11314293cur_ating
darting94020663dar__ting
derating103222283der_ating
deviating14311083deviating
divaricating1953593divaricating
drifting13338733_drifting
emaciating1546823emaciating
eradiating1248733eradiating
evacuating1645683evacuating
evaginating1644913evaginating
evaluating1456023evaluating
expiating1938543expiating
fabricating1945033fabricating
fainting123312163fa_inting
farting114120753far__ting
filiating1339253filiating
foliating1339253foliating
fritting123510703_fritting
furcating1537783furcating
gaiting93716583ga_i_ting
garaging1139043gar_aging
garoting10510703gar_oting
garotting1136113garotting
garroting1136953garroting
glaciating1445603glaciating
gradating1237323gradating
grating93923183_gr_ating
grifting13299263_grifting
gritting10309983_gritting
gyrating1337453gyr_ating
habiting1437533habi_ting
herniating1445983herniating
irrigating1245953irrigating
irritating1146293irritating
karting123716063kar__ting
lactating1239193lactating
laminating1348733laminating
lapidating1445243lapidating
laureating1146393laureating
mandating1339773mandating
marginating1545893marginating
marinading1445613marinading
marketing1636513marketing
marting103325013mar__ting
mediating13311203mediating
meriting11314693meri_ting
navigating1545003navigating
obviating1545053obviating
opiating11410093_opiating
orating83520323_or_ating
overeating141016533overeating
overhating17910953overhating
overrating14814203overrating
paginating1447533paginating
painting113614423pa_inting
palliating1347893palliating
palpating1438543palpating
parading12313863par_ading
parawing14310583par_awing
parbaking1877203parbaking
parenting12611583parenting
pargeting1338283pargeting
parlaying1537303parlaying
parroting1239153parroting
partaking1698673partaking
parting103527383par__ting
patinating1339883patinating
pirating11314513pir_ating
prating103424453_pr_ating
printing113216083_printing
radicating1459073radicating
rarifying1646313rarifying
rating74938703__r_ating
rifting113515003__rifting
rioting82716393__rioting
sainting93215733sa_inting
salivating1447443salivating
sanitating1149653sanitating
scripting1437473scripting
serrating10513213serrating
sprinting12310033sprinting
tainting93613583ta_inting
targeting1137303targeting
tariffing1644113tariffing
tarting84222653tar__ting
threating131010053threating
throating1398403throating
treating92519613_treating
triaging102610543_triaging
uprating11311113upr_ating
urinating10310653_urinating
vaccinating1945193vaccinating
vacillating1744623vacillating
vailing113817953va_i_ling
valeting1238853va_leting
vanishing1646313vanishing
variant10316803varia__nt
variate101316433variat__e
variated121211393variat_ed
variates111214983variat_es
variational1444783variational
varieties1259213varieties
varnishing1744473varnishing
varooming1545083varooming
varying1429723var__ying
vatting113614853va__tting
vaulting12227233va_ulting
vaunting12338753va_unting
verifying1936413verifying
vesicating1646903vesicating
vialing113614163v__ialing
vibrating1537483vibrating
violating1337443violating
visiting1238393visi_ting
vomiting1437733vomi_ting
waisting123615213wa_isting
waiting113618953wa_i_ting
warranting1444743warranting
writing113713893_wri_ting

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411627.67319372.0
3Display Results1621620.0602700.0
 (SQL Overall)1786911628.16921874.3
 
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.