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

106 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
hirseled1210625(None) 
hirselled1344681hirselled
hirsled11118111hirs_led
chiseled1435882chi_seled
dieseled1035522dieseled
hanseled1237712hanseled
hirpled13157142hir_pled
hirsel9138682hirsel__
hirsels10128342hirsel_s
hirsle9159572hirs_le_
hirsles101510072hirs_les
houseled1237282houseled
morseled1147192morseled
tinseled935762tinseled
airshed11258533airs_hed
airspeed1143603airspeed
aisled74516183ai_s_led
barreled1137843barreled
birdseed1243253birdse_ed
birled94416993bir__led
bristled11187343bristled
burseed1049503burse_ed
chiseler1335903chi_seler
chiselled1544213chi_selled
circled1237583cir_cled
corbeled1338373corbeled
corselet10414573corselet
corseted11311473corseted
creeled104012013_creeled
dirled84514903dir__led
driveled1374973driveled
easeled8159853_easeled
ferreled1234843ferreled
girdled10217453gir_dled
grueled937133_grueled
handseled1444403handseled
hanselled1345473hanselled
hardened1338613hardened
harkened1637483harkened
harshened1644453harshened
harslet10315653hars_let
hassled11358303h_assled
hayseed1435633hayse_ed
heeled104018413h__eeled
herself1337623hersel_f
higgled13339073hi_ggled
hilled104022223hi__lled
himself1544283himsel_f
hindered1339453hindered
hirable121612313hirable_
hired95226263hir___ed
hiree85427803hir_e_e_
hirees95117293hir_e_es
hirple11158973hir_ple_
hirples12149643hir_ples
hirseling1396273hirseling
hirsute1084523hirsute_
hissed104114453hi_s_sed
hisself1335913hissel_f
histed104420243hi_s_ted
hoarsened1344053hoarsened
horsed105321083hors__ed
horseless1237213horseless
horsemen1347483horsemen
horseweed1694663horseweed
hoseyed1436953h_oseyed
hosteled1237283hosteled
houselled1346193houselled
hoveled14209293h_oveled
hurdled12379833hur_dled
hurled104617453hur__led
hurtled11339593hur_tled
hustled113210133h_ustled
isled64615993_i_s_led
jerseyed1942743jerseyed
kerneled1344033kerneled
kirtled12287033kir_tled
libeled10249413li_beled
linseed838203linse_ed
marveled1436433marveled
misled94719313mi_s_led
mispled12310463mi_spled
misrelied1247243misrelied
misruled1137083misruled
morselled1245953morselled
nickeled15115513nickeled
oilseed835783oilse_ed
parceled1338343parceled
reeled74725533__reeled
shriveled1643153shriveled
streeled9267863streeled
tasseled935593tasseled
teaseled9186793teaseled
thirled11328093thir__led
thirsted1235213thirs_ted
tinselled1044413tinselled
tirled74714363tir__led
unreeled91310333unreeled
vesseled1243803vesseled
viseed105310983vi_se_ed
warsled112910443wars_led
warstled12286123warstled
weaseled12175143weaseled
whirled14368043whir__led
whistled1595783whi_stled
worsened1236053worsened

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621067.25020160.3
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.72023146.5
 
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.