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 “monie” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

151 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
monie7563165(None) 
monde85723141monde
monied94319461monied
monies83233161monies
monte75829771monte
movie105319131movie
moxie144018121moxie
bogie89524102bogie
bone65949322bon_e
bonier84321992bonier
bonne75124712bonne
bonnie85314852bonnie
bonze165119352bonze
cone67256962con_e
conge85227592conge
coni65534802coni_
conic95329792conic
conies84338592conies
conin76232722conin
conine84528552conine
conte76633202conte
cosie74728262cosie
cozie163519132cozie
dobie84920332dobie
dogie75222792dogie
done55747912don_e
donee66931012donee
donne65520462donne
donsie7613642donsie
dowie94721142dowie
doxie136017152doxie
fogie96719002fogie
genie66124922genie
gone55639042gon_e
gonia64117532gonia
gonif94320922gonif
goonie73615562goonie
homie104622532homie
hone77549322hon_e
honied104818392honied
honkie133011672honkie
ionic74622662ionic
ionise63516942ionise
ionize154613872ionize
koine9516482koine
lone45849132lon_e
longe66626462longe
looie55624242looie
loonie64216452loonie
louie55023512louie
mamie95826002mamie
mane65052032man_e
mange84930192mange
mania75634152mania
manic94629442manic
manse75528232manse
mavie104722562mavie
meanie83718392meanie
meinie82614522meinie
mense75025632mense
minae75627722minae
mince95325232mince
mine67256172min_e
mini65634562mini_
minim97321602minim
minis75432992minis
minke115421762minke
mobile103613542mobile
mode75840302mo_de
modi76826312modi_
moggie103210102moggie
moil65534092mo_il
moire71017322moire
moke106234222mo_ke
mole66251832mo_le
molies84429512molies
moline84422032moline
mollie83517102mollie
mome85239352mo_me
momi87524482momi_
mon57561582mon__
monad85519472monad
monas74732152monas
mondes94322352mondes
mondo85721232mondo
money104826842money
monger94418332monger
mongo810122412mongo
mongoe94214982mongoe
moniker1338672moniker
monish114217592monish
monism104016312monism
monist84324982monist
monk105928522mon_k
monkey153710592monkey
monks116123392monks
mono66036722mon_o
monos75930862monos
mons68152262mon_s
montes84226932montes
month104818422month
mony96830012mon_y
moonier93714102moonier
moose76327192moose
mope86838042mo_pe
mopier103914782mopier
morae75831192morae
more67154522mo_re
morse76032702morse
moste75925082moste
mote67048082mo_te
motif10519682motif
motile83818342motile
motive113112142motive
motte75526972motte
moue65835572mo_ue
mouse77133002mouse
move96630722mo_ve
movies115118452movies
moxies154317402moxies
muni65824412muni_
munis75022002munis
muonic10410182muonic
nonce75719822nonce
none45743172non_e
once65423082_once
one37050912_on_e
oorie53026362oorie
ponce95222512ponce
pone65747532pon_e
ponied94920702ponied
ponies84833462ponies
sonde64622832sonde
sone46649982son_e
sonic75225292sonic
sonsie6614862sonsie
tone46953742ton_e
tonic74727652tonic
tonier65520712tonier
tonne54921432tonne
toonie63617992toonie
towie85821872towie
townie93312302townie
vogie95116662vogie
yoni77524392yoni_
yonic105920842yonic
yonis85020822yonis
yowie114616452yowie
zonae145116442zonae
zone135231082zon_e
zowie174313842zowie

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001511.39038705.0
3Display Results1511510.0463282.6
 (SQL Overall)1786911511.529116867.9
 
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.