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

289 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
mignon93795(None) 
mignons1037861mignons
chignon1344622chignon
lignan75510322lignan
lignin74911192lignin
micron103714282micron
midnoon1044682midnoon
mignonne1142912mignonne
mikron12318502mikron
minion83416242minion
minnow1135582minnow
minor74920062mi_nor
ninon55517382ni_non
pigeon949412pigeon
pinon76024532pi_non
signor73510352signor
tiglon737912tiglon
tigon63914442tig_on
wigeon1037222wigeon
agon56531883_ag_on
amigo86515463amig_o_
amigos94511203amig_os
amino75425503ami_no_
anon46134853__anon
argon65520593arg_on
bicron103710773bicron
biggin103710603biggin
bighorn1346063bighorn
bignonia1144233bignonia
bigos85020013big_os
bigot84828323big_ot
billon83713823billon
bingo86020093bingo_
bingos95514793bingos
bison75716983bi_son
cannon84514443cannon
canon74725303_canon
chignons1444713chignons
cion613330913ci__on
citron83112983citron
cogon89120903cog_on
diglot83014333diglot
dingo74720793dingo_
dino56036753di_no_
dinos65428063di_nos
dipnoan1044653dipnoan
diuron738573diuron
eggnog941973eggnog
eikon939463ei_kon
epigon937963epig_on
fanon84619013_fanon
fino76034693fi_no_
finos86226953fi_nos
gibbon1135323gibbon
gibson935123gibson
gigaton946343gigaton
giglot84013133giglot
gigot74023073gig_ot
gipon84212413gi_pon
giron66118993gi_ron
goon57236173__goon
guenon736403guenon
hagdon1188283hagdon
icon66922043_i_con
igloo6410493_igloo
ignore7269063_ignore
ikon85814953_i_kon
imino74315233imino_
ingot61221063_ingot
inion54620183_inion
inn36727433_i_n_n
ion36051023_i__on
ionone6313443_ionone
iron46728463_i_ron
jingo134615213jingo_
jinn115420243ji_n_n
kinin94917323ki_nin
kino86233613ki_no_
kinos96626143ki_nos
lagoon7410483lagoon
legion75712983legion
ligan67920283lig_an
lignans8398853lignans
lignins84010493lignins
ligroin848043ligroin
linen55728723li_nen
lingo66022113lingo_
linin58025523li_nin
linn46034593li_n_n
lino46343373li_no_
linos55631503li_nos
lion46334443li__on
logion76013723logion
logon615922313log_on
lorgnon844423lorgnon
macon94519953m_acon
macron103615673macron
maggot10311703maggot
magian9312833magian
magnet9320663magnet
magneton1144943magneton
magnum1136733magnum
magot8326393mag_ot
mammon939643mammon
mango85724313mango_
mangos94319333mangos
mannan85413623mannan
mano66536793m_ano_
manor78023923m_anor
manos74933613m_anos
maroon83118203maroon
marron83717543marron
mascon103612743mascon
mason74820183m_ason
matron83918313matron
megaron10248293megaron
megaton10269843megaton
melon73922083m_elon
melton8311553melton
meno66031353m_eno_
merlon83012353merlon
meson74118313m_eson
miaou7513083mi_aou
miaow1058353mi_aow
micro94715993micro_
microns113814783microns
micros104115363micros
midden104112853midden
midiron1046003midiron
midnoons1144403midnoons
midtown1343673midtown
mien65028363mi__en
miens76118303mien_s
mig65646083mig___
migg85716803mig__g
miggle104012113miggle
miggs96311373mig_gs
might113827083mig_ht
mights123516253mights
mighty154310203mighty
migrant10314313migrant
migs76935323mig__s
mikrons13428413mikrons
mikvos1554023mikvos
mikvot1556763mikvot
milden94113153milden
million91813133million
milneb1095953milneb
milo65536103mi_lo_
milos75428013mi_los
mimeo96018683mimeo_
mimeos104511543mimeos
mina65136913mi_n_a
minae75627723mi_nae
minas75434113mi_nas
mince95325233mi_nce
mincy125817413mi_ncy
mind75434373mi_n_d
minds85427123mi_nds
mine67256163mi_n_e
mined85333353mi_ned
miner76933543mi_ner
mines75651953mi_nes
mingle93518783mingle
mingy115520183mi_ngy
mini65634553mi_n_i
minim97321603mi_nim
mining94225453mi_ning
minions93314623minions
minis75432993mi_nis
mink106636523mi_n_k
minke115421763mi_nke
minks115829273mi_nks
minnows1234913minnows
minny104518663mi_nny
minors85117093mi_nors
mint66758053mi_n_t
mints76834043mi_nts
minty106323903mi_nty
minus75223933mi_nus
minx137723343mi_n_x
minyan1138173minyan
mirin75023153mi_rin
mirror848003mirror
miscoin11311433miscoin
misdo85413183misdo_
misdone10310863misdone
misgrow1344433misgrow
misgrown1443983misgrown
misjoin1637693misjoin
misknow1643213misknow
misknown1742533misknown
miso67229903mi_so_
misos76523293mi_sos
mispen10312173mispen
mission9312743mission
misunion1084943misunion
mitten83914093mitten
mizen164815273mi_zen
mizzen16447953mizzen
mon57561573m___on
mongo810122413mongo_
mongoe94214983mongoe
mongol94912533mongol
mongos94318623mongos
mono66036713m_ono_
monos75930863m_onos
moon67140813m__oon
morion86217733morion
moron76925423m_oron
motion85217553motion
mouton8410853mouton
mungo84916053mungo_
mungos94311373mungos
munnion935863munnion
muon65722733m__uon
muton73817003m_uton
mutton8510453mutton
ninons64913773ni_nons
niton55418283ni_ton
omicron1165063omicron
omikron1353173omikron
organon845913organon
pennon8310643pennon
phonon114012033phonon
piano76118713piano_
pianos84315933pianos
pigeons1039183pigeons
piggin103111093piggin
pignoli1045443pignoli
pignora10306363pignora
pignus937953pignus
pignut9311573pignut
pigpen1136583pigpen
pingo87122713pingo_
pingos95317673pingos
pinion83815893pinion
pinons86019943pi_nons
pinot78737293pi_not
pinyon11459763pinyon
pion67235293pi__on
piston83515923piston
piton76121583pi_ton
region74614903region
ribbon1036533ribbon
rigor62714053rig_or
segno64814743segno_
segnos73610443segnos
sigloi737733sigloi
siglos7311463siglos
sign55523053sig__n
signa66114703sign_a
signal73711483signal
signed83413753signed
signee73617233signee
signer74015633signer
signet73621153signet
signing92713963signing
signior835043signior
signora8348503signora
signore8329093signore
signori8347893signori
signors83410903signors
signory11427523signory
signs65516323sign_s
simoon858063simoon
siphon1138463siphon
smidgeon12303273smidgeon
tenon53320513_tenon
tiglons837333tiglons
tigons74112253tigons
trigon74513103trig_on
turnon638193turnon
vigneron1243013vigneron
vigor92612423vig_or
vino76128433vi_no_
vinos84723073vi_nos
virion9310683virion
vision9311313vision
waggon1136393waggon
wagon94312953wag_on
widgeon1244143widgeon
wigan95114393wig_an
wigeons1136983wigeons
winnow1234593winnow
wino75933613wi_no_
winos84625043wi_nos
xenon122612453_xenon
zircon1754953zircon

Search took 7 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.1231452772.4
2DLD Change Limit1127162896.05018630.7
3Display Results2892890.0933107.5
 (SQL Overall)1786912896.26628517.6
 
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.