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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
misheard144625(None) 
mishear1238391mishear_
mishears1338321mishears
misaward1464592misaward
mislead10419972mislea_d
misleared1277452misleared
mislearn1045342mislearn
misread10339722misrea_d
airhead1136993airhea_d
bighead14126653bighea_d
diehard1237053dieh_ard
discard11310213dis_card
dished114318713dishe__d
dishware1545433dishware
disregard1243253disregard
fished134316313fishe__d
fisher124917143fishe_r_
fishers134714723fishe_rs
fishery16397733fishe_ry
heard95222753___heard
mashed125325043mashe__d
masher114123203mashe_r_
mashers124621053mashe_rs
masthead1435883masthea_d
meshed124415933meshe__d
miched143913393miche__d
midyear1343343midyear_
midyears1443403midyears
milliard1147033milliard
misadd1037163mis__add
misawards1563793misawards
misbrand1346413misbrand
misdeal1037663misdea_l
misdeals1147223misdeals
misdealt1147973misdealt
misdeed113211053misde_ed
misease92713043mis_ease
miseat82925703mis_ea_t
miseats92815783mis_eats
miser75430403mis_e_r_
misers85025703mis_e_rs
misery114113543mis_e_ry
misfed124113023misfe__d
misfeed13389683misfe_ed
mishap1338863mish_a_p
mishaps1438713mish_aps
mishearing1647883mishearing
mishegaas1562193mishegaas
mishmash18133423mishmash
mislaid1039293mis_laid
misleads11358543misleads
mislearned1383483mislearned
mislearns1144513mislearns
mislearnt1195553mislearnt
misled94719313misle__d
mismark1536703mis_mark
mispart111113773mis_part
misplead1345023misplea_d
misreads11268923misreads
misrecord1443913misrecord
missaid10310293mis_said
misseat93617233missea_t
misseated12610113misseated
misseats104011683misseats
missed94423603misse__d
missend104411373misse_nd
misstart10410033misstart
misteach1545443misteach
misted93625823miste__d
mistend103812523miste_nd
mister84728563miste_r_
misterm114314513miste_rm
misters93927503miste_rs
misword1338413mis_word
mither114218563mithe_r_
mithers123516733mithe_rs
moshed124517493moshe__d
mosher114719793moshe_r_
moshers124017843moshe_rs
mushed124420843mushe__d
musher113820573mushe_r_
mushers124016433mushe_rs
mustard10359533mus_tard
outheard1288543outheard
pinhead13347073pinhea_d
pished124817063pishe__d
pisher114317753pishe_r_
pishers123815753pishe_rs
pithead13419593pithea_d
reheard11309023_reheard
shard96125963__sh_ard
shear85424833__shear_
sheared114516003__sheared
shears93820903__shears
sherd96321153__she_rd
unheard1136943_unheard
visard103910123vis__ard
wished134417513wishe__d
wisher123617063wishe_r_
wishers133215213wishe_rs

Search took 9 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.1701051123.5
2DLD Change Limit1461621008.62616944.4
3Display Results1001000.0303333.3
 (SQL Overall)1786911008.82620246.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.