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

94 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
midsize194639(None) 
midsized2144731midsized
midlife13248302midlife
midline102315102midline
midsole1037812midsole
midwife16225522midwife
missile92815402missile
missive122413142missive
amidine103613853amid_ine
assize1538633_assize
bedside1156843bedside
capsize2037623capsize
didie74120573did_i_e
disseize1847183disseize
emissive1345923emissive
fissile10269653fissile
idolize1737783_idolize
inside7613453_inside
iodize164112593_iodize
ionize154613873_ionize
kiddie12359403kiddi_e
kidlike1137063kidlike
lionize1668823lionize
maderize2049073maderize
maize164618563m__aize
massive12289773massive
mediae94217413med_iae
midair937993midai_r
midairs1037203midairs
middies113116153middies
middle103414983mid_dle
midge95016563mid__ge
midi75628493mid_i__
midis85923423mid_i_s
midlifer14215793midlifer
midlines112613333midlines
midlist10312513midlist
midlives14287463midlives
midrib1138243midri_b
midribs1235513midribs
midriff1645513midriff
mids76541803mids___
midship1546043midship
midships1645693midships
midsoles1137763midsoles
midspace1543953midspace
midst85922563mids__t
midsts95510053mids_ts
midwifed18233933midwifed
midwifes17234713midwifes
midwived18263553midwived
midwives17274803midwives
millime112511403millime
milline92519113milline
minimize2146063minimize
miosis83615163miosi_s
misate81222693mi_sate
miscite11314383miscite
miscue10412223mi_scue
misdate101413963misdate
misdial1039643misdial
misdid10510573misdi_d
misdone10310863misdone
misdrive1446683misdrive
mise66043593mi_s__e
misfile122611553misfile
misfire12229893misfire
misgive13339033misgive
mislie83219153mi_slie
mislike132914833mislike
mislive122812693mislive
misprize2147543misprize
missies93423983missies
missiles103015083missiles
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
missives133212843missives
mistime11312613mistime
misuse83213643mi_suse
modiste1039283modiste
mudsill1045163mudsill
mudslide1243593mudslide
omissive1345103omissive
outsize162411753outsize
oxidize2444983oxid_ize
pintsize1955103pintsize
resize154117723_resize
size135630973___size
unisize1647343unisize
upsize17267303_upsize
visive1257873vi_sive
widdie113410733widdi_e

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 Limit134027947.23618522.2
3Display Results94940.0462043.5
 (SQL Overall)178691947.68823242.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.