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 “advecting” 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
advecting164511(None) 
adverting1437221adverting
addicting1485072addicting
adducting1494302adducting
advection1545552advection
advections1645552advections
advective1845232advective
advocating1744482advocating
affecting1845232affecting
averting122512732a_verting
abducting1584083abducting
abetting1158293a_betting
abreacting1544533abreacting
absenting1236993absenting
accenting1487823accenting
accepting1695803accepting
acting95920983a___cting
adapting1236643ad_apting
adducing1384113adduc_ing
adeeming1254793ad_eeming
adhering1338883adhe_ring
adjective2244813adjective
adjusting1843833adjusting
admitting1345033admitting
adopting1237453ad_opting
adulating1178713adulating
advancing1643063advancing
advect12309123advect___
advected1534533advect_ed
advects13276013advect__s
adventive1645813adventive
adventuring1652973adventuring
advertent1356593advertent
advertise1346103advertise
advertising16143613advertising
advertize2245383advertize
advertizing25144303advertizing
advising1336153adv_ising
agenting1039383a_genting
alerting91312383a_lerting
arresting1038633arresting
assenting1038163assenting
asserting1038663asserting
attesting1036383attesting
avenging1345863a_venging
averring12239063a_verring
aviating12311013a_viating
bisecting1436973bisecting
cathecting1844833cathecting
caveating1539293caveating
convecting18310433convecting
coveting141912303cove_ting
davening13258873dave_ning
decking153915593_d_ecking
defecting162510223defecting
dejecting20217793dejecting
denting94422183_d_enting
detecting13259983detecting
devesting14249903devesting
devoting1338823_devoting
dieting93616833_die_ting
directing1338823directing
diverting142410333diverting
divesting14298483divesting
ducting113713593_d_ucting
dueting93814393_due_ting
duetting1047183_duetting
effecting1845583effecting
ejecting18268163_ejecting
electing112113783_electing
erecting112415063_erecting
everting122213133_everting
evicting1437483_evicting
expecting2146693expecting
exsecting1935933exsecting
harvesting1744413harvesting
ideating10311703id_eating
infecting15109673infecting
injecting1997693injecting
inventing13109973inventing
inverting131013223inverting
investing13119393investing
objecting2144053objecting
obverting1536303obverting
refecting152413353refecting
rejecting192211153rejecting
resecting122816483resecting
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
riveting12139443rive_ting
rivetting13256413rivetting
selecting12310533selecting
venting114218093__venting
vesting114618683__vesting
vetting114216563__vetting
wadsetting1542913wadsetting

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.436409841.7
2DLD Change Limit148641976.37623312.6
3Display Results97970.0303233.3
 (SQL Overall)178691976.84226116.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.