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

262 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
priapi103792(None) 
priapic1346021priapic
periapt11313412periapt
priapism1456242priapism
priapus1134352priapus
primi95017402pri_mi
primp115615922primp_
primps124711822primps
argali75013753argali
aria46245423aria__
ariary94114203ariary
arias55438023aria_s
ariosi64313033ariosi
biali73419073_biali
biriani945643biriani
bravi104715753br_avi
briar75718153bria_r
briard94311293briard
briars84814823briars
briary114912003briary
crap85731843cr_ap_
crape96128443cr_ape
craps95328643cr_aps
crimp115615803crimp_
crimps124613453crimps
crimpy15489393crimpy
cripe95521143cri_pe
crisp95014623crisp_
crisps104411513crisps
crispy13478563crispy
diapir9357113_diapir
drape85319633dr_ape
drip76223953dri_p_
drippy14445653drippy
drips85417233dri_ps
dript86923873dri_pt
euripi856083euri_pi
frap95925813fr_ap_
fraps105620553fr_aps
friar85414273fria_r
friars93812093friars
friary124010093friary
grape84824663gr_ape
graph115315613gr_aph
grapy115416433gr_apy
grigri833853grigri
grip76127023gri_p_
gripe84622963gri_pe
grippe115310323grippe
grippy14447763grippy
grips85520133gri_ps
gript85126173gri_pt
gripy115115253gri_py
impi85415793__impi
okapi1136613_okapi
oribi7311093ori_bi
origami1045453origami
padi76331783p__adi
palapa10310673palapa
palpi95414553p_alpi
pap76758403p__ap_
papa85827143p__apa
pappi84810893p_appi
paps86443453p__aps
paraph13311263paraph
pariah114320583paria_h
pariahs123812343pariahs
parian83223963paria_n
parians93519733parians
perhaps1446123perhaps
periapsis1344833periapsis
periapts1237273periapts
periti8319953peri_ti
phial10313203phia_l
phials1158873phials
pia56848033p_ia__
pial65636703p_ia_l
pian66136093p_ia_n
pianic103714123p_ianic
piano76118713p_iano
pians75126963p_ians
pias66542553p_ia_s
piki106520563p_i_ki
pilei74021783p_ilei
pili66130353p_i_li
pimp106024903p_imp_
pimps114616983p_imps
pip78051043p_i_p_
pipal95118353p_ipal
pipe86434433p_i_pe
pipit95224873p_i_pit
pippin92810303p_ippin
pips85837133p_i_ps
pipy115421513p_i_py
piracy1339473piracy
pirana8713263pirana
pirate82322883pirate
piratic11314293piratic
piraya1167713piraya
pirogi9299013pirogi
pliant83918823pliant
polypi13458593polypi
praam94815613pr_aam
praams10459643praams
prahu105013973pr_ahu
prairie938333prairie
praise84419413praise
pram85733493pr_a_m
prams96125513pr_ams
prang84820323pr_ang
prank115019453pr_ank
prao66229023pr_a_o
praos74923563pr_aos
prase76128753pr_ase
prat65952043pr_a_t
prate75135983pr_ate
prats76333393pr_ats
prau66529473pr_a_u
praus74621753pr_aus
prawn105312433pr_awn
praxis154012253pr_axis
pray96331533pr_a_y
prays105022433pr_ays
preach133613923preach
preact103220393preact
preamp1238993preamp
preamps1336613preamps
prearm104512353prearm
preop94715873preop_
preops104911943preops
prep86427673pr_ep_
prepaid12310133prepaid
prepay13310313prepay
preppie1058093preppie
preppy1235523preppy
preps96220693pr_eps
pretape113511623pretape
priapean1243373priapean
priapisms1545463priapisms
price93725413pri_ce
priced115018883priced
pricer103918293pricer
prices104524543prices
pricey134412633pricey
prick134317503pri_ck
pricks144414263pricks
pricky174210343pricky
pricy124814563pri_cy
pride84724733pri_de
prided103618033prided
prides94324183prides
pried84426863pri_ed
prier75027763pri_er
priers84521193priers
pries74339533pri_es
priest84125423priest
prig75924873pri__g
prigs85219703pri_gs
prill74117943pri_ll
prills84015613prills
prim85132203pri__m
prima95019343pri_ma
primacy1635603primacy
primage12169143primage
primal104014623primal
primary1437703primary
primas104418103primas
primate111516283primate
prime96525603pri_me
primed115118913primed
primer105118683primer
primes104225263primes
primly13439623primly
primo95017913pri_mo
primos104514423primos
primped14479153primped
primping15338893primping
prims95425933pri_ms
primsie1137543primsie
primus103712173primus
prince104114763prince
principi1443933principi
prink114719673pri_nk
prinks124315383prinks
print74837463pri_nt
prints84320103prints
prion75119993pri_on
prions84317783prions
prior74316173pri_or
priors83914483priors
priory114110263priory
prise74632613pri_se
prised94322203prised
prises84133173prises
prism94820263pri_sm
prisms104915503prisms
prison8514023prison
priss74623893pri_ss
prissy11347853prissy
privacy1744233privacy
private121513263private
privet113821343privet
privy13439833pri_vy
prize164718943pri_ze
prized184415393prized
prizer174714883prizer
prizes173819813prizes
proa66229963proa__
proas75028803proa_s
prompt12313013prompt
prop85932813pr_op_
props95726883pr_ops
protei82615313protei
psoai7469923psoa_i
ragi56032283_r_agi
rai37658223_r_a_i
raki87127833_r_aki
rami66034093_r_ami
rani46640113_r_ani
rap56261963_r_ap_
rape65041633_r_ape
rapid86422033_r_apid
raps66247733_r_aps
rapt67245313_r_apt
reap65934743_reap_
reaps75626193_reaps
ria36745503_ria__
rial45938093_ria_l
rials55026673_rials
riant55833153_riant
rias45540593_ria_s
riata54618023_riata
rip56851303_ri_p_
ripe66038923_ri_pe
rips66237433_ri_ps
rishi8311253_rishi
tipi69924433_ti_pi
tragi64717173tr_agi
trap67532803tr_ap_
traps75727483tr_aps
trapt76433393tr_apt
triac74116373tria_c
triacid1038593triacid
triacs83913223triacs
triad65217723tria_d
triadic1037833triadic
triads74513533triads
triage72812893triage
trial54926353tria_l
trials64319883trials
triazin1638203triazin
trip66830393tri_p_
tripe75425383tri_pe
trippy13457803trippy
trips74923363tri_ps
uraei53016083ur_aei
urari54619963ur_ari
urial54823023uria_l
urials64415193urials
wrap96821973wr_ap_
wraps105617153wr_aps
wrapt105123183wr_apt

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162625.22021593.1
3Display Results2622620.0763447.4
 (SQL Overall)1786912625.66931520.7
 
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.