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

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

139 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
hurting11391403(None) 
hunting114317121hunting
hurling113616411hurling
hurtling12318311hurtling
hutting113016031hutting
airting83616302airting
blurting11258772blurting
bruting102612992bruting
bunting103718832bunting
burking143716322burking
burling104421132burling
burning104215502burning
burping124012942burping
burring104016992burring
bursting1138702bursting
burying133413912burying
busting104221792busting
butting103519282butting
carting104228282carting
charting142614192charting
churning14237172churning
churring14298652churring
chuting132910732chu_ting
courting112514572courting
curating11314292curating
curbing123814022curbing
curding113515132curding
curing94824782cur_ing
curling104320182curling
curring103616842curring
cursing104217032cursing
curving133912102curving
cutting103817492cutting
darting94020662darting
ducting113713592ducting
dueting93814392dueting
dunting93418382dunting
during84419402dur_ing
durning93511732durning
dusting93618992dusting
farting114120752farting
furling114016562furling
furring114013142furring
girting93113332girting
gurging102910112gurging
gusting93917162gusting
gutting93415922gutting
hafting144014172hafting
halting114419072halting
hanting114124482hanting
haring104233002har_ing
harking154120942harking
harming133717932harming
harping134118382harping
hasting114725192hasting
hating104929712h_ating
hatting113920232hatting
haunting123510052haunting
hearting12513122hearting
heating114024322heating
hefting144510912hefting
henting113719652henting
herding122915122herding
herring113615882herring
hilting113316892hilting
hinting113919222hinting
hiring104421602hir_ing
histing113720372histing
hitting113017272hitting
hooting113919882hooting
hording123517052hording
horning113015002horning
horsing113215582horsing
hosting114318382hosting
hotting113116522hotting
huffing17278832huffing
hugging132710632hugging
hulking153910982hulking
hulling113619012hulling
humming153310672humming
humping153213072humping
huntings12328052huntings
hurdling13288012hurdling
hurlings12388212hurlings
hurrying15145532hurrying
hushing144514472hushing
husking154312052husking
hustings12378682hustings
hustling12228792hustling
jurying18337762jurying
justing153615162justing
jutting153313712jutting
karting123716062karting
lunting83817742lunting
luring73820752lur_ing
lurking123710852lurking
lusting83619322lusting
luting75221752lu_ting
marting103325012marting
munting103718772munting
muring95120372mur_ing
musting103221072musting
muting93921522mu_ting
nurling84215822nurling
nursing84012552nursing
nutting83316232nutting
ousting84021352ousting
outing74128152ou_ting
outring84021022outring
parting103527382parting
porting103021782porting
punting103318442punting
purging113314182purging
purling103620292purling
purring104515822purring
pursing103715552pursing
putting103218572putting
quirting18238382quirting
quoting17310042quoting
rusting83821262rusting
rutting82718042rutting
shirting123213612shirting
shorting122514802shorting
shunting123610432shunting
shuting113212052shu_ting
shutting12309692shutting
sorting83221812sorting
spurting113111632spurting
suiting83419002suiting
surfing112914482surfing
surging93115432surging
tarting84222652tarting
tufting11289872tufting
turfing113010052turfing
turning83713182turning
turtling9238832turtling
tutting83515912tutting
urging83413122_urging
urping93914052_urping

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711393.40631612.2
3Display Results1391390.0463021.7
 (SQL Overall)1786911393.82846680.0
 
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.