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

248 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
wheaten133640(None) 
wheatens1454661wheatens
beaten84617062_beaten
cheapen14407622cheapen
cheated134416342cheated
cheater124816962cheater
eaten55323052__eaten
greaten83610642greaten
hearten102411752_hearten
heated104525592_heated
heater94828302_heater
heathen133410892_heathen
heaven123912602_heaven
neaten64214542_neaten
theater104014252theater
threaten1146302threaten
uneaten7412542uneaten
weaken13349602w_eaken
wheat114924572wheat__
wheatear1442562wheatear
wheats125013222wheat_s
wheen115016052whe__en
whetted14256692whetted
whetter13348802whetter
whiten124111922wh_iten
wreathen14256142wreathen
beater84729393_beater
bleated104015973bleated
bleater94515303bleater
chasten124312403chasten
cheapens15305943cheapens
cheaper144010583cheaper
cheat105732453cheat__
cheaters133613513cheaters
cheating144014523cheating
cheats114519543cheat_s
chelate122914893chelate_
chelated142610483chelated
chelates132713843chelates
chested133811673chested
chorten122811303chorten
cleated103417843cleated
create85126383create_
created104323453created
creates95225203creates
creatin93618133creatin
deaden83714323_deaden
deafen10389673_deafen
eater54639843__eater
feater95224053_feater
greatens9307593greatens
greater84416493greater
haen76229453_h_a_en
hapten115312983_hapten
hasten95718563_hasten
hate78450173_h_ate_
hated95734023_h_ated
hater85034753_h_ater
hates86742573_h_ates
haven114718533_h_aven
headed114020473_headed
headend12398363_headend
header104422543_header
headmen13259513_headmen
healed105121443_healed
healer94221803_healer
heaped124516903_heaped
heaper114119523_heaper
hearer94323643_hearer
hearken14338023_hearken
hearted113314023_hearted
heartens113010153_heartens
heat77061423_heat__
heaters104225223_heaters
heath115724283_heat_h
heathens143210153_heathens
heather133914853_heather
heaths126316383_heaths
heathy156111213_heathy
heating114024323_heating
heats85838403_heat_s
heave114521813_heave_
heaved134717863_heaved
heavens13439303_heavens
heaver124819673_heaver
heaves124120303_heaves
hefted134911423_hefted
hefter124313923_hefter
hematein1387013_hematein
hematin121516023_hematin
hempen1338963_hempen
hented104218753_hented
ideate7313683ideate_
ideated9310973ideated
ideates8313733ideates
khazen2233773kh_azen
laten54328343__laten
leaden74515223_leaden
leaven95013073_leaven
lenten6312883_lenten
meated94222403_meated
meatmen1138243_meatmen
miseaten10310773miseaten
neatens73310403_neatens
neater64424313_neater
oaten55222403__oaten
oleate6318883oleate_
oleates7417833oleates
outeaten8310423outeaten
paten74827343__paten
peahen113410133_peahen
peasen84815963_peasen
pecten102711103_pecten
phaeton1235973phaeton
phenate12412203phenate_
phenates13611583phenates
platen84518203_platen
pleated103816633pleated
pleater93916333pleater
reheated122415003reheated
reheater113413033reheater
seamen84518563_seamen
seated75131063_seated
seater64534163_seater
shaken134113613sh_aken
shapen114414653sh_apen
shaven124213303sh_aven
sheafed14388973sheafed
sheared114516003sheared
shearer104414683shearer
sheath12412893sheat_h
sheathe1348993sheathe
sheathed1547223sheathed
sheather1458233sheather
sheathes14610193sheathes
sheaths1358753sheaths
sheave124514003sheave_
sheaved143411633sheaved
sheaves134412973sheaves
shebeen1234553shebeen
sheen85023313she__en
sheeted113813043sheeted
sheeter103814913sheeter
sheitan1036573sheitan
shelter103214963shelter
shorten103511413shorten
shotten10288463shotten
sweated113411543sweated
sweater103712723sweater
sweeten10267313sweeten
teated74924023_teated
theaters114211903theaters
theatre10358493theatre
theatres11298633theatres
thecate123210023thecate_
threated1259203threated
threatens1254673threatens
treated83618703treated
treater74219833treater
unbeaten1038013unbeaten
unheated121514553unheated
waken124818473w__aken
water84733313w__ater
waxen154911813w__axen
weakens14367063w_eakens
weaker134015443w_eaker
weakon13357623w_eakon
wean75734353w_ea__n
weaned103816153w_eaned
weaner93816773w_eaner
weapon11288113w_eapon
wearer94319403w_earer
weasel93410523w_easel
weason93210823w_eason
weather133513223w_eather
weave115218533w_eave_
weaved133913483w_eaved
weaver123916613w_eaver
weaves123616373w_eaves
ween75835463w_e__en
weeted103913793w_eeted
welted103715823w_elted
welter93417383w_elter
wester94222893w_ester
western102911103w_estern
wetted103717023w_etted
wetter93919443w_etter
whale115517433wh_ale_
whaled134612033wh_aled
whaler124611973wh_aler
whales124716943wh_ales
what105434073wh_at__
whats117718993wh_at_s
wheal115716183whea__l
wheals124512523whea_ls
wheatears1542683wheatears
wheatland1641953wheatland
wheatless1534003wheatless
whee105429593whe__e_
wheel115515333whe__el
wheeled14318463wheeled
wheeler13298773wheeler
wheelmen1643313wheelmen
wheens124610613whe__ens
wheep136214353whe__ep
wheeped16387503wheeped
wheeze21276813wheeze_
wheezed23296453wheezed
wheezer22296673wheezer
wheezes22306803wheezes
whelmed16375153whelmed
whelped16355633whelped
when105723043wh___en
whence14187923whence_
where117019423whe_re_
wherein13216593wherein
whereon13196503whereon
wheres125917433whe_res
whereto1346063whereto
wherve15568113wherve_
wherves16548053wherves
whet105133783whe_t__
whether16346623whether
whets115019613whe_t_s
whetters14246653whetters
whetting1535973whetting
wheyey1834323whe_yey
whisted144010013whisted
white114920303wh_ite_
whited134814083wh_ited
whitens13428733wh_itens
whiter124316393wh_iter
whites123919883wh_ites
whitey154911883wh_itey
whitter139110893whitter
wreaked15369023wreaked
wreaker143610043wreaker
wreath124111193wreat_h
wreathe13339053wreathe
wreathed15257463wreathed
wreather14268603wreather
wreathes14299893wreathes
wreaths13338373wreaths
wreathy16326063wreathy
wrested113410933wrested
wrester102812413wrester
written10336343written
zeatin15412823_zeatin

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272486.76619808.9
3Display Results2482480.0763263.2
 (SQL Overall)1786912487.24824653.8
 
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.