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

177 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
preform143960(None) 
perform1439271perform
preforms1537391preforms
reform11312701_reform
deform1259612_deform
freeform1644692freeform
paraform1546922paraform
performs1547472performs
piefort1249532piefort
piriform1555742piriform
prearm104512342pre_arm
preboom1348242preboom
prefer113813202prefer_
prefers123713332prefers
prefire124012812prefire
preformat1646362preformat
preformed17176202preformed
preinform1644742preinform
prereform1644292prereform
presort95219532presort
preterm11310152preterm
pretor8315742pretor_
pretors9316802pretors
prewarm14479602prewarm
prework164210902prework
preworn124711212preworn
proforma1545432proforma
proreform1643892proreform
pyriform1844392pyriform
reforms1239812_reforms
triform1237842triform
aciform1446003aciform
aeriform1346083aeriform
aliform1247033aliform
arciform1544783arciform
auriform1345173auriform
ausform1245233ausform
before11410153_before
beworm1339983_beworm
biform1368123_biform
conform14310453conform
defoam1238563_defoam
deforms1337803_deforms
deiform1336683deiform
deworm1249523_deworm
enorm74415633__enorm
fireworm1646683fireworm
form95836873___form
gruiform14103363gruiform
inform11310153_inform
isoform1244963isoform
lyriform1643533lyriform
misform1437513misform
oviform1544813oviform
paraforms1645563paraforms
pediform1645183pediform
perforce1544963perforce
performed17155293performed
performer16145133performer
perm85834633p_e__rm
phenom1339473pheno_m
piciform1764993piciform
piedfort1444873piedfort
pieforts1344863pieforts
piliform1555473piliform
pinworm1467173pinworm
pisiform1564963pisiform
planform1544753planform
platform1544583platform
plexiform2342313plexiform
plexor1535253plexor_
plexors1645423plexors
postform1556203postform
praetor938973praetor_
praetors1039833praetors
prearms11369173pre_arms
preboard1338263preboard
preboil1148943preboil
prebook1557523prebook
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
precure11312553precure
predry1237863pre_dry
prefab1336243pref_ab
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefatory1746683prefatory
prefect141011073prefect
prefile123413183prefile
prefired144310753prefired
prefires134313283prefires
prefix18356853pref_ix
preflame1545913preflame
prefocus1544743prefocus
preformats1744413preformats
preforming1846233preforming
prefroze2264673prefroze
prefund1335733prefund
preinforms1743233preinforms
prelim10311423pre_lim
preload1049813preload
premium13310363premium
premold1247863premold
premolt11312073premolt
premoral1249713premoral
premorse1237553premorse
prenoon9310043prenoon
preop94715873pre_o_p
preops104911933pre_ops
preoral9312673pre_oral
prepare111913623prepare
prerock1536723prerock
prescore124812353prescore
presoak1348453presoak
presold1059603presold
presong1039843presong
presorts105311673presorts
pressor93512873pressor_
pressors103212673pressors
prestore104217343prestore
preterms1237223preterms
pretold1049083pretold
pretrim11310773pretrim
preverb14317063preverb
prewar114712573prewar_
prewarms15406723prewarms
prewarn124410143prewarn
prewire124311133prewire
preworks17599003preworks
preyer114413733preyer_
preyers124412363preyers
prior74316173pr_ior_
priors83914483pr_iors
priory114110263pr_iory
proem94818273pr__oem
prom87631693pr__o_m
rearm75923563_re_arm
rebore86625643_rebore
reborn810016953_reborn
record96117423_record
recork126315483_recork
refer84822143_refer_
refers93921083_refers
refilm114311403_refilm
refire95419473_refire
refold103812113_refold
reforge11259033_reforge
reformat1357653_reformat
reformed14249603_reformed
reformer13217953_reformer
refry114412463_ref_ry
reinform1346183_reinform
remora8414583_remora
reniform1346223_reniform
report85326013_report
resorb84914343_resorb
resort65728613_resort
retiform1345853_retiform
retore67630763_retore
retorn610923423_retorn
retort66831143_retort
rewarm115913483_rewarm
reword106321403_reword
rewore938030153_rewore
rework136619783_rework
reworn98122193_reworn
trefoil1066063trefoil
tremor84210393tremor_
tremors93711213tremors
uniform1247053uniform
ursiform1343743ursiform
variform1644993variform
waveform1943543waveform
wireworm1645883wireworm

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.220812231.8
2DLD Change Limit1340271776.71619956.4
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.99925530.9
 
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.