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

155 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
midgut10351005(None) 
midget103718451midget
midguts11296011midguts
fidget114216482fidget
hindgut1245012hindgut
midcult1246302midcult
midge95016552midg_e
midges103516482midges
midgets113910252midgets
midst85922552mid_st
might113827082mi_ght
miscut10614822miscut
nidget83715642nidget
widget113815262widget
aidful1057073aidful
amidst94913233amid_st
bidet84935623bid_et
bight118728843bi_ght
bigot84828323bi_got
blindgut1242453blindgut
budget104618123budget
catgut9310803catgut
dadgum1134583dadgum
daut56443563__daut
didact10711203didact
didst74619613did_st
dight104027003di_ght
digit73825273di_git
dimout9414243dimout
dingus83611843dingus
disgust937643disgust
eight94928053ei_ght
fidge104516063fidg_e
fidged124610933fidged
fidges114114393fidges
fidgets12388763fidgets
fidgety15384893fidgety
fight124027093fi_ght
gadget93616183gadget
gigot74023073gi_got
gigue71210673gi_gue
gut46753853___gut
hideout1179793hideout
hight125327233hi_ght
hindguts1343013hindguts
idiot6718863_idiot
ingot61221063_ingot
input7314653_input
light94429603li_ght
lingua7509913lingua
maggot10311713maggot
magot8326393m_agot
magus85318753m_agus
mahout11415813mahout
maut65448453m__aut
medium113711623medium
medius93613283medius
miaou7513083miaou_
miaous8511693miaous
miaul71612123mi_aul
mid67354473mid___
midair937993midair
midcap1336473midcap
midcults1343223midcults
midday13327503midday
midden104112853midden
middle103414983middle
middy124812593mid_dy
midi75628483mid__i
midis85923413mid_is
midleg1038553midleg
midlist10312513midlist
midmost1246153midmost
midnight1544493midnight
midrib1138243midrib
mids76541793mid__s
midsts95510053midsts
midway15327153midway
mig65646083mi_g__
migg85716803mi_g_g
miggle104012113miggle
miggs96311373mi_ggs
mights123516253mi_ghts
mighty154310213mi_ghty
migs76935323mi_g_s
mikvot1556763mikvot
mildest102812063mildest
milium104712683milium
millet84030743millet
milt65455813mi__lt
mindful1344613mindful
mindset10313343mindset
mingle93518783mingle
mingy115520183ming_y
minium106014423minium
mint66758063mi__nt
minuet82621033minuet
minus75223933mi_nus
minute83414293mi_nute
misact10316693misact
miscue10412223miscue
miscuts1139183miscuts
misdoubt1394073misdoubt
miseat82925713miseat
misfit112813833misfit
mishit112618203mishit
mislit83019693mislit
mismet103722373mismet
misset85028153misset
missout9412663missout
missuit9911303missuit
missus85312293missus
mist66154533mi__st
mitt66145493mi__tt
mixt136831923mi__xt
mixup1636773mi_xup
modest93818453modest
modus85417203mod_us
mogul8310213m_ogul
mongst93512603mongst
morgue938113morgue
mudbug1243253mudbug
mudcat11311203mudcat
muggur10325593muggur
mut58357183m___ut
nidgets9358143nidgets
nidus65913573nid_us
night94327853ni_ght
oidium959813oidium
pidgin10259813pidgin
pignut9311573pignut
pigout9314613pigout
qiviut1846613qiviut
redout71820253redout
rident7520193rident
ridge75018673ridg_e
ridged94014223ridged
ridgel8399973ridgel
ridges85817013ridges
ridgil8316823ridgil
ridgy104110643ridg_y
right94430503ri_ght
rotgut738793rotgut
siddur834573siddur
sight94629293si_ght
smidge10378483smidg_e
smidgen11426513smidgen
smidges11448193smidges
smidgin11335103smidgin
tidbit938493tidbit
tight93626503ti_ght
wideout1179033wideout
widest104517003widest
widgets12318453widgets
wight123725573wi_ght

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161555.29621283.2
3Display Results1551550.0463369.6
 (SQL Overall)1786911555.71831250.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.