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

91 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
obtesting124588(None) 
attesting1036382attesting
besting104923922_b_esting
contesting13312212contesting
detesting112610322detesting
objecting2144052objecting
obsessing1244262obsessing
obverting1536302obverting
outeating10814492outeating
retesting102614602retesting
testing86021052__testing
abetting1158293ab_etting
absenting1236993absenting
arresting1038633arresting
basting104227203_b_asting
beating104326873_b_eating
beestings12335923_beestings
beeswing14255763_beeswing
belting104119133_b_elting
betting103921403_b_etting
biestings12266033_biestings
blasting114013433_blasting
bleating113514503_bleating
blessing1137593_blessing
boasting113512503_boasting
boosting113311053_boosting
breasting1239583_breasting
bursting1138703_bursting
busting104221793_b_usting
coattesting1443453coattesting
congesting14410113congesting
contenting13313323contenting
cresting114017043_cresting
detecting13259983detecting
devesting14249903devesting
digesting12208673digesting
divesting14298483divesting
egesting1039013_egesting
foresting13311363foresting
guesting1058463_guesting
hostessing1444573hostessing
infesting13109513infesting
ingesting11129623ingesting
intestine9411853intestine
investing13119393investing
jesting154317713__jesting
lutestring1143473lutestring
molesting1237753molesting
nesting84320443__nesting
obeying1336543ob_e_ying
observing1544393observing
obtaining1236773obtaining
obtest81213013obtest___
obtested1135453obtest_ed
obtests9136233obtest__s
obtruding1344123obtruding
obtunding1354243obtunding
obturating1346573obturating
obviating1545053obviating
orienting1038723orienting
ousting84021353o__usting
outacting1239213outacting
outasking1437313outasking
outdating11810863outdating
outfasting1446333outfasting
outfeasting1543843outfeasting
outlasting1137523outlasting
outrating10916403outrating
outseeing1038333outseeing
outsing83320463out_s_ing
outswing1259283out_swing
outvoting1336823outvoting
outwasting1446433outwasting
patenting1248943patenting
pretesting131810683pretesting
priesting1239483priesting
protesting131910253protesting
questing1838273_questing
reesting93118273_reesting
renesting102514703renesting
resting85031183__resting
retasting102513413retasting
revesting132814123revesting
stetting93410713_stetting
tasting84624213__tasting
tenting84621153__tenting
unresting10311133unresting
vesting114618683__vesting
westing115020273__westing
wresting123811833_wresting
zesting174515333__zesting

Search took 10 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.453394461.4
2DLD Change Limit148641918.51617454.3
3Display Results91910.0461978.3
 (SQL Overall)178691919.01519821.5
 
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.