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

166 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
prostate1031453(None) 
prostates11314421prostates
prostrate11412481prostrate
apostate1049852apostate
aristate8312132aristate
costate94019272_costate
cristate10310602cristate
postage103214852p_ostage
postdate1139652p_ostdate
pristane10310342pristane
probate11414482pro_bate
proette9312362proet_te
prolate9419792pro_late
pronate9418872pro_nate
prorate9418732pro_rate
prostatic13410852prostatic
prostie91617742prost_ie
prostrated1349422prostrated
prostrates12411992prostrates
prostyle13187272prostyle
proustite1147112proustite
pyrostat1347162pyrostat_
pyrostats1444912pyrostats
restate73824882_restate
roseate7613452_roseate
rostrate8313842_rostrate
rotate63320342_ro_tate
tristate8311032tristate
aerostat8410683aerostat_
aerostats946723aerostats
apostates1149163apostates
aristae7312533arista_e
bistate9313823_bistate
bromate11313553bro_mate
corotate102813933corotate
costae85319683_costa_e
crispate1246913crispate
cristae9310613crista_e
cristated1247423cristated
croustade1243943croustade
cryostat1395743cryostat_
cryostats1444213cryostats
eructate1047333eructate
estate64719763__estate
fossate10388603_fossate
frontage1296243frontage
frostbite1443413frostbite
frottage1245083frottage
frustrate1245583frustrate
gestate83614073_gestate
gyrostat1244563gyrostat_
gyrostats1343273gyrostats
hastate10313913_hastate
hostage113111233_hostage
instate71616483_instate
irritate867873irritate
microstate1448013microstate
misstate10711343misstate
notate63217863_no_tate
outate62923403__outate
outstate81411993outstate
pectate112214693p_ectate
peltate92013773p_eltate
perorate10417923pero_rate
personate112111423personate
phonate12411813pho_nate
phorate12413363pho_rate
phosphate1977273phosphate
plottage1144433plottage
portage103013643p_ortage
postages112815323p_ostages
postal84317533p_osta_l
postals93716383p_ostals
postbase1246443p_ostbase
postdated1346883p_ostdated
postdates1248863p_ostdates
postface1566123p_ostface
postgame1345523p_ostgame
posthaste1456603p_osthaste
postie84123963p_ost_ie
postrace12310543p_ostrace
posttax1645533p_osttax
postulate1169813p_ostulate
posture9313253p_osture
potage92715903p_o_tage
potato8513433p_o_tato
pottage103310603p_ottage
prate75135983pr___ate
predate10616893pr_edate
prelate9519693pr_elate
presage10312293pres_age
presale9416353pres_ale
preshape1537533preshape
prestamp1445323prestamp
prestige11310733prestige
prestore104217353prestore
pretape113511623pr_etape
pretaste10139523pr_etaste
primate111516283pr_imate
priorate10411733priorate
pristanes11410433pristanes
pristine10313503pristine
private121513263pr_ivate
probated13410863pro_bated
probates12414283pro_bates
procreate1348143procreate
proettes10312763proet_tes
profane122111863pro_fane
prograde1247183prograde
promote11313143pro_mote
pronated11414053pro_nated
pronates10418373pro_nates
propagate1446123propagate
propane112716153pro_pane
prophage1649433prophage
prophase15410243prophase
propitiate1447383propitiate
prorated11513713pro_rated
prorates10418073pro_rates
prorogate1247693prorogate
prosaic11311163pros_aic
prosateur1143583pros_ateur
prose75835123pros___e
prosect11313393prosect_
prosected14158633prosected
prosects1239473prosects
prosecute1345953prosecute
proselyte1444843proselyte
prosit85124593pros_it_
prosomata1346743prosomata
prossie91812963pros_sie
prost75434103pros__t_
prostatism1447743prostatism
prosties101421193prosties
prostitute1255193prostitute
prostyles14157113prostyles
protases102115033pro_tases
protatic12314753pro_tatic
protease10209893protease
protege1059153pro_tege
protonate11412573protonate
protrade1148213protrade
protyle12229453pro_tyle
proustites1246453proustites
proximate2045773proximate
prussiate1144523prussiate
pulsate9510233puls_ate
punctate1246473punctate
reslate73520593_reslate
restage83316193_restage
restated93120183_restated
restates83423443_restates
rootage839053_rootage
rosette7310373_rosette
rosulate8310903_rosulate
rotated82715293_ro_tated
rotates72819773_ro_tates
rotte54625933_ro_t_te
state56237333___state
substate101711093substate
testate73916233_testate
tractate10411003tractate
troostite944733troostite
unstate71916213_unstate
upstate91610493_upstate
urostyle11173953urostyle

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 Limit1461621667.56319325.9
3Display Results1661660.0632634.9
 (SQL Overall)1786911668.06222164.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.