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

178 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
propjet183991(None) 
projet15315181pro_jet
prophet14316031prophet
propjets1935491propjets
droplet10312112droplet
poppet92717322p_oppet
project1838452pro_ject
projets1639162pro_jets
propel103714062prop_el
proper104319952prop_er
prophets1539502prophets
propmen1338762propmen
propped113311962propped
brocket154013383brocket
crochet143616663crochet
crocket154615673crocket
cropped143812073cropped
cropper133312973cropper
croquet1859683croquet
crownet123714113crownet
droplets1136063droplets
dropout10410003dropout
dropped13329293dropped
dropper12329873dropper
dropt86924433drop__t
froglet11310063froglet
grommet12268453grommet
grope84821613grop_e_
groped107515063grop_ed
groper94517253grop_er
gropes95220403grop_es
kopje1835273_kopje_
kopjes1935363_kopjes
moppet126915093_moppet
objet141213143__objet
parapet11317643parap_et
paroquet1947283paroquet
people10310193people_
peopled1238513peopled
peopler1138083peopler
peoples11312223peoples
piolet83225643pio_let
pipet95533323p_ip_et
plopped11288773plopped
pocket144622623p_ocket
poet65552903p_o__et
pooped113915943poop_ed
pope85535613p_op_e_
popes95933813p_op_es
popped104117813p_opped
popper93615963p_opper
poppets10338853p_oppets
posset84923253p_osset
premeet11615153premeet
prepped11329903prepped
prepreg12165963prepreg
preset84430983pr_eset
pricket153616443pricket
privet113821343pr_ivet
probate11414483probate
probe94320813pro_be_
probed114114823pro_bed
prober104516073pro_ber
probes104119453pro_bes
probit103218353pro_bit
problem1335983problem
proceed12310553proceed
prodded1257733prodded
prodder1147953prodder
product1279233product
proem94818273pro__em
proette9312363proette
proffer15126933proffer
profit113016273pro_fit
progged12409803progged
progger11319373progger
projects1936413pro_jects
prolate9419793prolate
prole74527793pro_le_
proleg94612113pro_leg
proles84627203pro_les
promoed12310083promoed
promote11313143promote
prompt12313013pro_mpt
prompted1536903prompted
prompter1437983prompter
promptest1546063promptest
pronate9418873pronate
prone75332623pro_ne_
pronged113912393pronged
proofed13138723proofed
proofer12149103proofer
prop85932813prop___
propane112716153propane
propanes122415823propanes
propels113412843propels
propend123311273propend
propene112716043propene
propenes122816513propenes
properer1259203properer
properest1349663properest
propers113619033propers
property1547073property
prophecy2043913prophecy
prophesy1844453prophesy
prophetic18710583prophetic
propine113020213propine
propined133111513propined
propines122618933propines
propman1339063propman
propone112716303propone
proponed132412043proponed
proponent1349443proponent
propones122516963propones
propose112714843propose
proposed132011083proposed
proposer121810633proposer
proposes122515973proposes
propretor1345533propretor
propria1149933propria
propriety1645433propriety
props95726883prop__s
propyl13358183prop_yl
propyla14296633propyla
propyls14308193propyls
prorate9418733prorate
prose75835123pro_se_
prosect11313393prosect
prosed94921103pro_sed
proser84223463pro_ser
proses84733473pro_ses
prosier93817493prosier
prosiest10416523prosiest
prosit85124593pro_sit
prospect1447893prospect
prosper114012193prosper
prosses94019513prosses
prost75434103pro__st
protea82214763pro_tea
protect11313633protect
protei82615313pro_tei
protest9317533protest
protist9320223protist
prouder10310383prouder
proudest1138943proudest
prove104823193pro_ve_
proved125016033pro_ved
proven114314773pro_ven
prover113819723pro_ver
proves114322253pro_ves
provost1238573provost
prower114218123pro_wer
prowest12311533prowest
prowled13309913prowled
prowler123310013prowler
proxies163014933proxies
puppet93514593p_uppet
pyrope132810533pyrop_e_
pyropes142210193pyrop_es
ramjet15311543_ramjet
rochet115423003_rochet
rocket125425283_rocket
rope65542913_rop_e_
roped84630813_rop_ed
roper75431913_rop_er
ropes75940063_rop_es
ropey106021873_rop_ey
ropier84118813_ropier
ropiest93317773_ropiest
roquet154415893_roquet
roset55945243_ro_set
roupet84218343_roupet
sprocket1646773sprocket
trijet133916553tr_ijet
triplet94319213triplet
trippet113714113trippet
trope75725803trop_e_
tropes84824353trop_es

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.406440125.6
2DLD Change Limit1340271787.36018210.2
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.82922824.2
 
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.