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

173 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
predial103815411predial
praedial1178762praedial
predict12315322predict
predive13511082predive
prelim10311422preli_m
premium13310362premium
redia65524482_redia_
rediae74221992_rediae
redial74923112_redial
redias74523602_redias
uredia73610062uredia_
uredial82910482uredial
uredium1076692uredium
acedia9310393acedia_
acedias1039763acedias
bedim10313833_bedi_m
bedlam1149273_bedlam
bream95121813bre__am
brecham1646833brecham
cream95721343cre__am
credal9311673cred_al
credit9315193credi_t
credits1039973credits
dream85120393dre__am
gremial1039153gremial
iridium1046303iridium
media84721713_media_
mediad104313713_mediad
mediae94217413_mediae
medial93819863_medial
median94117543_median
medias93620783_medias
medium113711623_medium
paradigm1446243paradigm
parecism1458533parecism
pedal86022503p_ed_al
pedicab1446693p_edicab
pedlar93311273p_edlar
penial84120893p_enial
perdie94718513perdi_e
pereia85217983pereia_
peridia10312363peridia_
peridial11411923peridial
peridium1349023peridium
permian112612283permian
pietism1139113pietism
pleiad947833ple_iad
plenism11310113plenism
podia8415283p_odia_
podium112911913p_odium
praam94815613pr__aam
pram85733493pr___am
prandial1149643prandial
preamp1238993pre__amp
preanal9310713preanal
prearm104512343pre_arm
preaxial1746973preaxial
prebid113512843prebi_d
prebids12399873prebids
prebill1138803prebill
prebind123810643prebind
preboom1348243preboom
precipe133012123precipe
precis103416703preci_s
precise113518173precise
predate10616893predate
predatism1447283predatism
predawn1335353predawn
predeath1447003predeath
predicant1449393predicant
predicate14411773predicate
predicts1339613predicts
predraft1447593predraft
predried12309573predried
predries112714383predries
predrill1145933predrill
predry1237863pred_ry
predusk1443773predusk
preedit10512453preedi_t
preedits1168763preedits
preeing103817673preeing
prefab1336243pre_fab
prefile123413183prefile
prefire124012813prefire
prefix18356853prefi_x
prefixal2044543prefixal
preflame1545913preflame
preform1439603preform
pregame1239553pre_game
preheat12413893preheat
prelaw1139103pre_law
prelife1279943prelife
prelims1139823prelims
preload1049813preload
preludial1244873preludial
preman104117453pre_man
premeal11310513premeal
premie103617993premi_e
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premiums1437533premiums
premix173710333premi_x
premixt183510663premixt
prename11412643pre_name
preoral9312673preoral
prepaid12310133prepaid
prepay13310313pre_pay
prepill1147583prepill
preplan1149953preplan
preriot9316413preriot
presa74319043pre_sa_
preside10715613preside
presidia1147273presidia_
presidial1247213presidial
presidium1445303presidium
presift12312223presift
presoak1348453presoak
prestamp1445323prestamp
pretax152310193pre_tax
preterm11310153preterm
pretrial10511983pretrial
pretrim11310773pretrim
prevail1238243prevail
preview1536473preview
previse123713793previse
prewar114712573pre_war
prewarm14479603prewarm
prewire124311133prewire
prewrap14104973prewrap
prexies163415003prexies
preying133114553preying
priding113317543priding
priedieu1153983priedieu
prim85132203pr__i_m
prima95019343pr__ima
prism94820263pr__ism
prodigal1246003prodigal
prodigy1435573prodigy
proemial1249183proemial
program12311693program
protium11312283protium
prudish1376563prudish
pyemia1337553pyemia_
pyemias1436803pyemias
pyrexia19225463pyrexia_
pyrexial20234963pyrexial
pyrexias20224993pyrexias
radial74020393_radial
radian74117273_radian
radium93513293_radium
ream65841613_re__am
redan66125013_red_an
redbay1238333_redbay
redcap1158493_redcap
redear73515173_redear
redeem9311523_redeem
redials84416883_redials
redid74922393_redi_d
reding83825563_reding
redip87816963_redi_p
redips93713843_redips
redipt94116743_redipt
redraw10269853_redraw
redream10107913_redream
refilm114311403_refilm
reteam83214533_reteam
retia55326113_retia_
retial64724993_retial
tedium9269873_tedium
uremia82910893uremia_
uremias9249503uremias

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.206867432.0
2DLD Change Limit1340271737.29618369.9
3Display Results1731730.0602883.3
 (SQL Overall)1786911737.56223630.1
 
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.