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

255 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
preemies1251219(None) 
preemie11310561preemie_
premies113823061pr_emies
creepies1239612creepies
freebies1337872freebies
greenies9312672greenies
gremmies1355992gremmies
peeries93623022p_eeries
predries112714382predries
preedits1168762preedits
preempts1444542preempts
premie103617992pr_emie_
premier113515632pr_emier
premiers122911652pr_emiers
premise113818552pr_emise
premises123018272pr_emises
premiss113513812pr_emiss
premixes193110082pr_emixes
preppies1149682preppies
pretties10615132pretties
prexies163415002pr_exies
reemits9611302_reemits
armies85123693ar__mies
arteries8321483arteries
beedies10314203_beedies
breeches15258673breeches
breezes18318693bree_zes
breezier1934533breezier
breeziest2035063breeziest
breweries1447583breweries
creamier12319063creamier
creamiest13248933creamiest
creepie1137483creepie_
creepier1236253creepier
creepiest1337063creepiest
creeses93914623cree_ses
creeshes1336953creeshes
cremes104517993cr_em_es
crummies1437643crummies
demies94825803__demies
dreamier11287293dreamier
dreamiest12227223dreamiest
drearies92313413drearies
enemies9313693_enemies
eremites10312603er_emites
freebees1345353freebees
freebie1236043freebie_
freemen1238463freem_en
freesias1146333freesias
freezes193310353free_zes
frenzies2037713frenzies
greedier1036083greedier
greediest1147553greediest
greenie8310123greenie_
greenier938713greenier
greeniest1039033greeniest
gremmie1264383gremmie_
heresies11312693heresies
jemmies18318333_jemmies
kneesies1245543kneesies
orreries8310123orreries
peavies122213403p_eavies
peerie83617893p_eerie_
peeves113814873p_ee_ves
peewees1236803p_eewees
peewits12105873p_eewits
pennies94218813p_ennies
peonies93620153p_eonies
permits11314003p_ermits
perries93226603p_erries
phrensies1445743phrensies
pieties9419223p_ieties
pigmies122610993p_igmies
pineries102419083pineries
plenties10314693plenties
poesies93217403p_oesies
poetries10315583poetries
polemics1448183polemics
polemizes2248153polemizes
pommies133712843p_ommies
poperies12316793poperies
praecipes1544853praecipes
prairies10411453prairies
preaches153214893preaches
preadmits1444923preadmits
preambles1545333preambles
preamps1336613pream_ps
prebakes1639013prebakes
prebids12399883pr_ebids
preboils1267293preboils
precedes13310713precedes
precesses13310463precesses
precipes143212213precipes
precis103416703pr_eci_s
precise113518173pr_ecise
precises123218333precises
precodes13711573precodes
precures12312903precures
predates11615813predates
predefines1645433predefines
predried12309573predried
preedit10512463preedi_t
preedited1337633preedited
preeing103817673pree_ing
preeminent1445833preeminent
preempt1337723preem_pt
preempted1644683preempted
preened103214993pree_ned
preener93114833pree_ner
preeners102712813preeners
preening113115843preening
preens85020113pree__ns
prees75937173pr_e__es
preexcites2144163preexcites
preexist1747963preexist
preexists1844733preexists
prefaces15311063prefaces
prefades1439533prefades
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
pregames1339003pregames
preguides1344863preguides
prelacies13310053prelacies
prelates10418573prelates
prelimits1366013prelimits
prelims1139823pr_elims
prelives13310383prelives
preludes1137833preludes
premed114617763pr_em_ed
premedics1645303premedics
premeds12389593pr_emeds
premeet11615153pr_emeet
premen105017803pr_em_en
premiere12249233pr_emiere
premieres13288233pr_emieres
premised133013193pr_emised
premisses13288763pr_emisses
premium13310363pr_emium
premiums1437533pr_emiums
premix173710333pr_emi_x
premixed20338013pr_emixed
premixt183510663pr_emixt
prenames12311643prenames
prentices131111903prentices
prepares122014163prepares
prepaves15189193prepaves
preppie1058093preppie_
preppier1156643preppier
preppiest1236973preppiest
preprices1569263preprices
prepubes1436053prepubes
prepuces1438583prepuces
prereview1742993prereview
presages11312203presages
presales10315263presales
presences132113793presences
preserves14109073preserves
preships1539313preships
presides11414913presides
preslices1338213preslices
presses93523153pr_esses
prestiges12310593prestiges
presumes1239843presumes
pretapes122811533pretapes
pretences132312613pretences
pretenses112210593pretenses
preterites12411793preterites
preterits11410963preterits
pretermits1445033pretermits
pretrims1238983pretrims
prettied1159253prettied
prettier1069043prettier
prettiest1199803prettiest
pretypes15337263pretypes
preunites1138933preunites
prevails1337663prevails
preview1536473pr_eview
previews1634513pr_eviews
previse123713793pr_evise
previses133814283previses
prevues1239263pr_evues
prewires133811013prewires
prexes154915953pr_e_xes
prezes173614693pr_e_zes
priedieu1153983priedieu
priedieus1242943priedieus
pries74339533pr___ies
primes104225263pr_im_es
primines123013703pr_imines
priories10312453priories
prissies101712003prissies
privies122414263pr_ivies
proemial1249183proemial
proems104711163proem__s
proettes10312763proettes
progenies12314123progenies
promines123018803pr_omines
promise113415843pr_omise
promises122916763pr_omises
prossies101515223prossies
prosties101421193prosties
proxemics2244453proxemics
proxies163014933pr_oxies
pruderies1247873pruderies
pyaemias1545063pyaemias
pyemias1436803p_yemias
pygmies15205673p_ygmies
ramies84630463_r_amies
readies83324713_readies
redefies12710163_redefies
redenies9615713_redenies
redries83721713_redries
reedier83815303_reedier
reediest92815423_reediest
reedits8511743_reedits
reefier102912553_reefier
reefiest112811483_reefiest
reekier113111123_reekier
reekiest122711313_reekiest
reemit8717223_reemi_t
reeves94721493_ree_ves
reflies104418533_reflies
refries104419733_refries
regimes104514743_regimes
reifies104218283_reifies
relies65036423_r_elies
remedies11310553_remedies
remiges103015473_r_emiges
remise84221953_r_emise
remises93423483_r_emises
remiss84216353_r_emiss
remits85622943_r_emits
remixes164313873_r_emixes
replies94521043_replies
reties65436193_r_eties
retimes95020173_retimes
retries74129073_retries
reveries112518513_reveries
rhemes115913183_rhem_es
roomies93017243_roomies
rummies113212793_rummies
sheenies111411543sheenies
steelies8312553steelies
sweenies11148763sweenies
sweeties11159723sweeties
treaties8316983treaties
trendies9312213trendies
tweenies11146393tweenies
uraemias1046043uraemias
uremias9249503ur_emias
veeries102916893_veeries
weenies102915093_weenies
weepies122811743_weepies
wheelies1437863wheelies

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622557.86018595.7
3Display Results2552550.0932741.9
 (SQL Overall)1786912558.38921300.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.