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

133 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
thirsted123521(None) 
thirster1135671thirster
hirsled11118112_hirsled
histed104420242_hi_sted
thirled11328092thir_led
thirst9312252thirst__
thirsters1235232thirsters
thirstier1243692thirstier
thirsts1036242thirst_s
thirsty1354082thirst_y
thrusted1265222thrusted
twisted11277432twi_sted
whisted144010012whi_sted
agisted938203agi_sted
airshed11258533_airshed
airted74214503_air_ted
athirst1037873athirst__
bilsted1038033_bilsted
bursted1039423_bursted
charted135116853char_ted
chested133811673ch_ested
chirked173810333chir_ked
chirmed15379733chir_med
chirped15379783chir_ped
chirred133612123chir_red
christen13106703christen
cisted95217523_ci_sted
existed1538473exi_sted
fisted104218703_fi_sted
flirted11428673flir_ted
foisted113210603foi_sted
ghosted1236273gh_osted
girted83912873_gir_ted
hasted105125283_h_asted
heisted113210653_heisted
highted152710163_highted
hilted104016043_hi_lted
hinted104318323_hi_nted
hipster12288783_hipster
hired95226263_hir__ed
hirpled13157143_hirpled
hirsel9138683_hirs_el
hirseled12106253_hirseled
hirsle9159573_hirsle_
hirsles101510073_hirsles
hirsute1084523_hirsute_
hissed104114453_hi_ssed
hoisted113411293_hoisted
horsed105321083_hors_ed
horste94817413_horste_
horstes104516113_horstes
hosted105020343_h_osted
joisted15379173joi_sted
listed74322833_li_sted
misted93625823_mi_sted
oersted839553_oersted
pirated102515613_pirated
priested1138393priested
quirted17369213quir_ted
shifted14359983shi_fted
shirked153710463shir_ked
shirred113710503shir_red
shitted114212053shi_tted
shorted113614403shor_ted
skirted12388613skir_ted
spirited1148973spirited
spirted103913073spir_ted
stairstep1142103stairstep
tainted83512423tai_nted
tarted74923373t_ar_ted
tasted74123973t__asted
tested74421523t__ested
thicketed1943613thicketed
thieved1434973thi_eved
thighed1535273thi_ghed
thinned11399163thi_nned
third95912493thir___d
thirstiest1343973thirstiest
thirstily1542693thirstily
thirsting1335283thirsting
thirteen1143303thirteen
thirties1139723thirties
thirty12378403thir_t_y
thistle10107803thi_stle
thistles1198233thi_stles
thistly1395963thi_stly
thorite10313443thorite_
thorites11312393thorites
thorned11479403thor_ned
thrashed1555363thrashed
thrawed1435583th_rawed
threated1259203threated
threshed1535643threshed
thrilled1235493thrilled
thrived14458183th_rived
throated1247923throated
throned115412173th_roned
thruster1135793thruster
thwarted1533363thwarted
thyrse1235133thyrs_e_
thyrses1335023thyrs_es
thyrsoid1544193thyrsoid
tilted74616863t_i_lted
tincted1037273t_incted
tinted74419533t_i_nted
tipster9299053t_ipster
tired65228903t_ir__ed
tirled74714363t_ir_led
tissued835583t_issued
titrated92611683titrated
toasted84011923t_oasted
toileted936993toileted
toited74016753toi__ted
touristed1044303touristed
triste63818643tri_ste_
trusted83412793t_rusted
trysted11428273t_rysted
turreted935373turreted
twirled11385983twir_led
twister10308953twi_ster
twitted11326633twi_tted
waisted114210943wai_sted
whimsied1743113whimsied
whirled14368043whir_led
whirred14386933whir_red
whirried15154103whirried
whished17428023whi_shed
whishted1843153whishted
whisked18336913whi_sked
whistled1595783whi_stled
whited134814083whi__ted
wisted104120273_wi_sted
worsted1138013_worsted

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621336.06324107.2
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.51527427.6
 
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.