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

262 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
mignons103786(None) 
mignon937951mignon_
chignons1444712chignons
lignans8398852lignans
lignins84010492lignins
microns113814782microns
midnoons1144402midnoons
mignonne1142912mignonne
mikrons13428412mikrons
minions93314622minions
minnows1234912minnows
minors85117102mi_nors
ninons64913772ni_nons
pigeons1039182pigeons
pinons86019942pi_nons
signors83410912signors
tiglons837342tiglons
tigons74112262tig_ons
wigeons1136982wigeons
agons66423783_ag_ons
amigos94511213amig_o_s
argons75018203arg_ons
bicrons113410473bicrons
biggins113410693biggins
bighorns1445253bighorns
bigness1038193bigness
bignonia1144233bignonia
bignonias1243783bignonias
bigos85020013big_o_s
bigots95015133big_ots
billons93013363billons
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bi_nocs
bisons83914373bi_sons
cannons94412883cannons
canons85522063_canons
chignon1344623chignon_
cions75222853ci__ons
citrons92913223citrons
cogons96818113cog_ons
diglots9299503diglots
dingoes94114833dingoes
dinos65428063di_no_s
dipnoans1144103dipnoans
diurons838823diurons
eggnogs1041923eggnogs
eikons1038503ei_kons
epigons1048183epig_ons
fanons96115213_fanons
finos86226953fi_no_s
gibbons1234983gibbons
gibsons1045043gibsons
gigatons1046053gigatons
giglots9367863giglots
gigots83911953gig_ots
gipons9389603gi_pons
girons75014373gi_rons
goons65326773__goons
guenons836563guenons
hagdons1258523hagdons
icons76516493_i_cons
igloos738033_igloos
igneous835773_igneous
ignore7269063_ignore
ignores8269003_ignores
ikons96311013_i_kons
ingots7912063_ingots
inions64417003_inions
inns46920933_i_n_ns
ionone6313443_ionone
ionones7313883_ionones
ions46737853_i__ons
irons55324133_i_rons
jingoes153811443jingoes
jinns126013843ji_n_ns
kinins104014583ki_nins
kinos96626143ki_no_s
lagoons839253lagoons
legions84611783legions
ligans76817733lig_ans
lignan75510323lignan_
ligneous945233ligneous
lignin74911193lignin_
ligroins946823ligroins
linens64818393li_nens
lingoes84014693lingoes
linins65922143li_nins
linns56123333li_n_ns
linos55631503li_no_s
lions55923213li__ons
logions86211293logions
logons79818173log_ons
lorgnons943993lorgnons
macons104017243m_acons
macrons113514893macrons
maggots1136563maggots
magians10310753magians
magnetons1244543magnetons
magnets10311143magnets
magnums1234683magnums
magots9312363mag_ots
mammons1048513mammons
mangoes104316133mangoes
mangos94319343mango_s
mannans93611523mannans
manors84420883m_anors
manos74933623m_ano_s
maroons92615553maroons
marrons93216973marrons
mascons113411583mascons
masons83916513m_asons
matrons93517633matrons
megatons11279703megatons
melons84117713m_elons
meltons9410923meltons
merlons93311273merlons
mesons83215843m_esons
miaous8511693mi_aous
miaows1145473mi_aows
micron103714283micron_
micros104115363micro_s
middens11379383middens
midirons1145883midirons
midnoon1044683midnoon
midtowns1443243midtowns
miens76118303mi__ens
miggles113512033miggles
miggs96311373mig__gs
mights123516253mig_hts
migrant10314313migrant
migrants1138183migrants
migs76935323mig___s
mikron12318503mikron_
mikvos1554023mikvo_s
mildens10339933mildens
millions101712433millions
milnebs11113793milnebs
milos75428013mi_lo_s
mimeos104511543mimeo_s
minas75434113mi_n_as
minces104420803mi_nces
minds85427123mi_n_ds
miners84126633mi_ners
mines75651953mi_n_es
mingles103719003mingles
minims104514813mi_nims
mining94225453mi_ning
minings103912073mi_nings
minion83416243minion_
minis75432993mi_n_is
minkes124618783mi_nkes
minks115829273mi_n_ks
minnies93617363minnies
minnow1135583minno_w
minny104518663mi_n_ny
minor74920063mi_no_r
mints76834043mi_n_ts
minus75223933mi_n_us
minxes154612983mi_nxes
minyans1237263minyans
mirins83918903mi_rins
mirrors938623mirrors
miscoins12311083miscoins
misdoes10312493misdoes
misdone10310863misdone
misgrows1444963misgrows
misjoins1736913misjoins
misknows1743063misknows
misos76523293mi_so_s
mispens11311073mispens
missions10311903missions
misunions1154533misunions
mittens9349883mittens
mizens174610253mi_zens
mizzens17366123mizzens
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
monos75930863m_ono_s
mons68152263m___ons
moons75331003m__oons
morions94014643morions
morons84919543m_orons
motions94215003motions
moutons9410313moutons
muggins11248073muggins
mungoes103510463mungoes
mungos94311373mungo_s
munnions1035273munnions
muons75816173m__uons
mutons84314363m_utons
muttons949283muttons
ninon55517383ni_non_
nitons64614903ni_tons
omicrons1275193omicrons
omikrons1462963omikrons
ominous949033omi_nous
organons945583organons
pennons939713pennons
phonons123310253phonons
pianos84315933piano_s
pigeon949413pigeon_
piggins113010473piggins
pignoli1045443pignoli
pignolis1146053pignolis
pignora10306363pignora
pignus937953pign_us
pignuts1035613pignuts
pigpens1235503pigpens
pingoes105116523pingoes
pingos95317673pingo_s
pinions93413603pinions
pinon76024533pi_non_
pinones94717073pi_nones
pinots85920273pi_nots
pinyons12299003pinyons
pions75826393pi__ons
pistons93016373pistons
pitons85319043pi_tons
regions83613473regions
ribbons1136253ribbons
rigors72813713rig_ors
segnos73610443segno_s
siglos7311473siglo_s
signals8359163signals
signees83510803signees
signers84714443signers
signets83311503signets
signing92713963signing
signiors944923signiors
signor73510353signo_r
signora8348503signora
signoras9306553signoras
signore8329093signore
signori8347893signori
signory11427523signory
signs65516323sig__ns
simoons937943simoons
siphons1239353siphons
smidgeons13272733smidgeons
tenons62916603_tenons
tiglon737923tiglon_
tigon63914443tig_on_
trigons84312093trig_ons
turnons737863turnons
vignerons1343163vignerons
vigors102911483vig_ors
vinos84723073vi_no_s
vinous93914173vi_nous
virions1039873virions
visions10311023visions
waggons1235503waggons
wagons103911213wag_ons
widgeons1343853widgeons
wigans104511703wig_ans
wigeon1037223wigeon_
winnows1334533winnows
winoes94317013wi_noes
winos84625043wi_no_s
xenons132710483_xenons
zircons1854963zircons

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.420425454.8
2DLD Change Limit1340272626.78319759.3
3Display Results2622620.0932817.2
 (SQL Overall)1786912627.29624491.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.