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

112 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
russeting106532(None) 
gusseting1173961gusseting
russetings1182061russetings
russetting1184251russetting
basseting1236152basseting
cosseting1239542cosseting
russettings12101572russettings
rusting83821262ru_s_ting
assenting1038163_assenting
asserting1038663_asserting
bassetting1344633bassetting
bucketing1835713bucketing
budgeting1444023budgeting
buffeting1843783buffeting
bulleting1236643bulleting
bursting1138703burs_ting
busheling1535503busheling
bussing103614623buss__ing
busting104221793bu_s_ting
casketing1635383casketing
closeting1236183closeting
corseting12312173corseting
crusting113612793cru_s_ting
curveting1535353curveting
cussing103814273cuss__ing
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserting121310853disserting
dueting93814393du__eting
dusting93618993du_s_ting
fussing113611683fuss__ing
grummeting1642453grummeting
guesting1058463gues_ting
gussying1334063guss_ying
gusting93917163gu_s_ting
junketing2143093junketing
justing153615163ju_s_ting
lessening1045333lessening
lustering102711203lustering
lusting83619323lu_s_ting
misseating131310943misseating
missetting13107903missetting
mussing104015543muss__ing
mustering122212333mustering
musting103221073mu_s_ting
ousting84021353ou_s_ting
outseeing1038333outseeing
poussetting1452813poussetting
pulsating1236343pulsating
questing1838273ques_ting
quieting18228463qu_ieting
rabbeting1445183rabbeting
racheting1537793racheting
racketing1647873racketing
rassling939013rass_ling
reasserting1246153reasserting
reesting93118273rees_ting
remeeting12311433remeeting
renesting102514703renesting
reseating102421533reseating
resecting122816483resecting
reseeding112410493reseeding
reseeing92412623r_eseeing
reseeking14208493reseeking
resenting102619293resenting
resetting102816293resetting
resewing122712263r_esewing
resifting133512093resifting
resisting103215313resisting
resiting93521123r_esiting
resitting103414873resitting
reslating102516993reslating
resmelting1337263resmelting
resorting10614613resorting
respecting1549883respecting
respiting121912863respiting
restating102319413restating
resting85031183r_es_ting
resulting10311083resulting
retesting102614603retesting
revesting132814123revesting
riveting12139443r_iveting
roasting93012693roas_ting
rocketing1666973rocketing
roosting93411453roos_ting
roqueting1944603roqueting
rousting93913273rous_ting
rubbering1435703rubbering
ruinating1039593ruinating
rushing113817703ru_s_hing
russet6319433russet___
russets738163russet__s
russety1034613russet__y
russifying1743923russifying
rustling9249983ru_stling
rutting82718043ru__tting
suspecting1565703suspecting
sussing84013703suss__ing
tasseling1035853tasseling
trumpeting1543563trumpeting
trussing9268653truss__ing
trusteeing1142893trusteeing
trusting93411653tru_s_ting
tussling935823tuss_ling
unseating10713203_unseating
unseeing988293_unseeing
unsetting1088993_unsetting
unsewing1287433_unsewing
unsexing1686853_unsexing
upsetting1275563_upsetting
ushering1258923_ushering

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.1731032896.0
2DLD Change Limit1486411127.00021234.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.21924752.9
 
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.