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

202 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
preemie1131056(None) 
preemies12512191preemies
premie103617991pr_emie
creepie1137482creepie
freebie1236042freebie
greenie8310122greenie
gremmie1264382gremmie
peerie83617892p_eerie
preedit10512462preedit
preempt1337722preempt
premier113515632pr_emier
premies113823062pr_emies
premise113818552pr_emise
premix173710332pr_emix
preppie1058092preppie
reemit8717222_reemit
breeze17298963bree_ze
breezier1934533breezier
creamier12319063creamier
creepier1236253creepier
creepies1239613creepies
creese84014333cree_se
creme94319323cr_em_e
crummie1336153crummie
dreamier11287293dreamier
eerie55228533__eerie
eremite9312833er_emite
freebee1238043freebee
freebies1337873freebies
freeman1237343freeman
freemen1238463freemen
freesia1046323freesia
freeze18349513free_ze
greedier1036083greedier
greenier938713greenier
greenies9312673greenies
gremmies1355993gremmies
peeries93623023p_eeries
peeve104915253p_ee_ve
peewee11311963p_eewee
peewit111110903p_eewit
perdie94718513p_erdie
pereia85217983pere_ia
permit10321683p_ermit
polemic13311253polemic
polemize2148673polemize
pommie123710503p_ommie
praecipe1444633praecipe
prairie938333prairie
preadmit1346813preadmit
preamble1436383preamble
preamp1238993pream_p
preamps1336613preamps
prebade12310283prebade
prebake1539093prebake
prebid113512843pr_ebid
preboil1148953preboil
precede1239653precede
precipe133012123precipe
precis103416703pr_ecis
precise113518173precise
precode12311853precode
precure11312553precure
predate10616893predate
predefine1546173predefine
predive13511083predive
predried12309573predried
predries112714383predries
pree67044733pr_e__e
preed85128123pree__d
preedited1337633preedited
preedits1168763preedits
preeing103817673preeing
preeminent1445833preeminent
preempted1644683preempted
preemptive1944143preemptive
preempts1444543preempts
preen75925053pree__n
preened103214993preened
preener93114833preener
preening113115843preening
preens85020113pree_ns
prees75937173pree__s
preexcite2044683preexcite
preexist1747963preexist
preface14510923preface
prefade1339013prefade
prefile123413183prefile
prefire124012813prefire
prefix18356853pr_efix
pregame1239553pregame
preguide1255423preguide
prelate9519693prelate
prelife1279943prelife
prelim10311423pr_elim
prelimit1259123prelimit
prelims1139823prelims
prelude1038013prelude
premade12311443premade
preman104117453pr_eman
premeal11310523premeal
premed114617763pr_emed
premedic1546303premedic
premeds12389593premeds
premeet11615153premeet
premen105017803pr_emen
premiere12249233pr_emiere
premiers122911653pr_emiers
premised133013193pr_emised
premises123018273pr_emises
premiss113513813pr_emiss
premium13310363pr_emium
premixed20338013pr_emixed
premixes193110083pr_emixes
premixt183510663pr_emixt
premune1138933premune
prename11412643prename
prentice121012353prentice
prepaid12310133prepaid
prepare111913623prepare
prepave14228873prepave
prepense12238943prepense
preppier1156643preppier
preppies1149693preppies
preprice1488873preprice
prepuce1337833prepuce
prerace11414123prerace
prereview1742993prereview
presage10312293presage
presale9416353presale
prese75228383pr_e_se
presence122213513presence
preserve13108803preserve
preship1439793preship
preside10715613preside
preslice1258623preslice
prestige11310733prestige
presume11310303presume
pretape113511623pretape
pretence122312123pretence
pretense10199823pretense
preterit10315843preterit
preterite11613203preterite
pretermit1347133pretermit
pretrim11310783pretrim
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
pretype14387483pretype
preunite1039573preunite
prevail1238243prevail
preview1536473pr_eview
previse123713793previse
prevue1179163pr_evue
prewire124311143prewire
prexies163415003pr_exies
priedieu1153983priedieu
prime96525603pr_im_e
primi95017403pr_imi_
primine113214823pr_imine
primsie1137543primsie
proem94818273proem__
proemial1249183proemial
proems104711163proem_s
proette9312363proette
promine112819443pr_omine
promise113415843pr_omise
prossie91812953prossie
prostie91617743prostie
proxemic2146153proxemic
pyaemia1445733pyaemia
pyaemic1645873pyaemic
pyemia1337553p_yemia
pyemic1537893p_yemic
ramie75027823_r_amie
reedier83815303_reedier
reedit7617223_reedit
reefier102912553_reefier
reekier113111123_reekier
reemits9611303_reemits
reeve84121323_ree_ve
regime95313943_regime
remise84221953_r_emise
remit75737223_r_emit
remix145916553_r_emix
reremice1246023_reremice
retie55735303_r_etie
retime85321803_retime
reverie103615163_reverie
rheme106214053_rhem_e
roomie83013873_roomie
sheenie10159493sheenie
steelie7310213steelie
sweetie10157873sweetie
treelike1237003treelike
uraemia946503uraemia
uraemic1156543uraemic
uremia82910893ur_emia
uremic103410513ur_emic
weenie92612023_weenie
weepie11258793_weepie
wheelie1336193wheelie

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.390458182.1
2DLD Change Limit1340272027.01619103.1
3Display Results2022020.0802525.0
 (SQL Overall)1786912027.48623870.0
 
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.