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

84 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
midyear134334(None) 
midyears1443401midyears
mishear1238392mishear
aider65431133aid_e_r
bidder104114863bidde_r
bider85728373bid_e_r
cider84723313cid_e_r
cudbear1233333cudbear
dear55343603__d_ear
drear65016903__drear
dyer85522113__dye_r
eider64624743eid_e_r
endear74110013end_ear
hider95024083hid_e_r
idea59122773_id_ea_
ideal65716393_id_eal
ideas65919013_id_eas
idler65015663_idle_r
kidder123811093kidde_r
lidar6312723lid__ar
linear65113343li_near
livyer12426293livye_r
madder103515593madde_r
medlar93010463med_lar
midair937993mid_air
midcap1336473mid_cap
midday13327503mid_day
midden104112853midde_n
middens11379383middens
middler112712273middler
midge95016543midge__
midges103516473midge_s
midget103718443midge_t
midgets113910253midgets
midleg1038553midle_g
midlegs1156323midlegs
midterm12316013midterm
midway15327153mid_way
midweek1743273midweek
milder93818453milde_r
miler75733063mi_le_r
milker124814323milke_r
miller84625413mille_r
milter84921233milte_r
mimbar1297493mi_mbar
mimer94825763mi_me_r
mincer104017363mince_r
minder94822503minde_r
miner76933543mi_ne_r
minibar11106133minibar
minicar11109313minicar
minter84425103minte_r
minyan1138173miny_an
mirier83918363mirie_r
mirker123712693mirke_r
misdeal1037663misdeal
misdoer1048633misdoe_r
miseat82925703mi_seat
miser75430403mi_se_r
misheard1446253misheard
mishears1338323mishears
mislead10419973mislead
mislearn1045343mislearn
misread10339723misread
misseat93617233misseat
mister84728563miste_r
miter75734793mi_te_r
mither114218563mithe_r
mitier83620673mitie_r
mixer145017643mi_xe_r
modular1087363modular
mudder104413493mudde_r
mylar105311533m__ylar
redear73515173red_ear
ridder84015143ridde_r
rider65231303rid_e_r
sidearm1035963sid_earm
sidebar1045563sidebar
sidecar1045233sidecar
sidler74716963sidle_r
tidier73515113tidie_r
widder112913973widde_r
wider94826353wid_e_r
year76534253___year

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027848.03016690.8
3Display Results84840.0332545.5
 (SQL Overall)178691848.21921741.2
 
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.