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

240 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
prajna153507(None) 
prajnas1635451prajnas
fraena938062fraena
grana65722092gra_na
pirana8713262pira_na
prang84820322pra_ng
prank115019452pra_nk
prawn105312432prawn_
prawns11509022prawns
purana8712932pura_na
raja117918682_raj_a
amarna839793amarna
ana39559833__a_na
anna45529013__anna
apraxia1646893apraxia
arcana8912583arcana
arena55323813ar_ena
asana5315483asa_na
brahma1336193brahma
brain76229383brain_
brains85125473brains
brainy114815643brainy
bran65740383bra_n_
brand85124493bra_nd
brank115222283bra_nk
branny115111833branny
brans75437433bra_ns
brant74742173bra_nt
brava106414793bra_va
brawn106018563brawn_
brawns115614083brawns
brawny144710603brawny
braza165214253bra_za
bwana10310243bwa_na
canna75919333_canna
carina84325333carina
crane75331603cra_ne
crania82418433crania
crank114819613cra_nk
cranny114210273cranny
dharna1055263dharna
dracena1034923dracena
drain65222893drain_
drains73719403drains
drama85117423dra_ma
drank104816203dra_nk
drawn95614243drawn_
faena85014203_faena
farina94618233farina
fauna84816513_fauna
franc104615413fra_nc
frank124417513fra_nk
frena85915273fr_ena
ganja131410003_ganja
goanna736653goanna
grain65126253grain_
grains74223093grains
grainy103914213grainy
grama85620283gra_ma
gramma11499803gramma
grampa115010173grampa
gran56335013gra_n_
grand75122693gra_nd
granny104311163granny
grans64832543gra_ns
grant64840023gra_nt
grappa11396443grappa
hryvna1541573hryvna
hyaena1235363hyaena
jarina134014063jarina
jnana12159043jna_na
kana85928533_ka_na
krona93611793kr_ona
liana53915893lia_na
mana65341963_ma_na
manna75522543_manna
marina84623413marina
nana46632903_na_na
orang65119943ora_ng
organa789213organa
paca85132243p_a_ca
pacha126518063p_acha
padnag1036073p_adnag
paean77222723p_aean
pagan86121163p_agan
pain65647243p_ain_
pains75138283p_ains
paint75443693p_aint
paisa76021073p_aisa
pajama17317653p_ajama
palea75028663p_alea
pampa114913423p_ampa
pan58466453p_a_n_
panda85022613p_anda
pane64950293p_a_ne
pang75336303p_a_ng
panga85323543p_anga
panne76623653p_anne
pans65855733p_a_ns
pant66061263p_a_nt
papa85827143p_a_pa
para65242173p_a_ra
parang93715513parang
parent83230423parent
parian83223963parian
paring94236493paring
parka115120883p_arka
partan83820563partan
parura8310583parura
pasha105417183p_asha
pasta76624533p_asta
patina86022193patina
pavan106518473p_avan
pawn94625303p_awn_
pawns108818133p_awns
pean66147173pea_n_
peans75437643pea_ns
penna74520203p_enna
persona92812453persona
pian66136093pia_n_
piano76118713pia_no
pians75126963pia_ns
piazza1643823piazza
pina65842633p__ina
pinna75320183p_inna
piragua1044643piragua
piranas9912603pira_nas
piranha12126363piranha
piraya1167713pira_ya
plain74823303plain_
plains85019593plains
plaint85323203plaint
plan65833943pla_n_
planar84212713pla_nar
plane74929143pla_ne
plank115221143pla_nk
plans75731273pla_ns
plant75437113pla_nt
plasma103810913plasma
platan83913693platan
platina94413643platina
playa105812943pla_ya
plaza164311063pla_za
plena75816393p_lena
praam94815613pra_am
praams10459643praams
prahu105013973pra_hu
prahus11458243prahus
praise84419413praise
praline93019743praline
pram85733493pra__m
prams96125513pra_ms
prance104318573prance
prangs94816233prangs
pranks124814723pranks
prao66229023pra__o
praos74923563pra_os
prase76128753pra_se
prases84429023prases
prat65952043pra__t
prate75135983pra_te
prated94924923prated
prater84825353prater
prates84633163prates
prating103424453prating
prats76333393pra_ts
prau66529473pra__u
praus74621753pra_us
prawned1346743prawned
prawner1246803prawner
praxes156215183praxes
praxis154012253praxis
pray96331533pra__y
prayed124815433prayed
prayer114815293prayer
praying133717323praying
prays105022433pra_ys
preanal9310713preanal
preen75925053preen_
preens85020113preens
preman104117453preman
presa74319043pr_esa
prima95019343pr_ima
prink114719673pr_ink
print74837463pr_int
prion75119993prion_
prions84317783prions
proa66229963pr__oa
projet15315183projet
prolan8414693prolan
prone75332623pr_one
prong85218113pr_ong
protea82214763protea
prune75119633pr_une
pruta7314243pr_uta
prying124114803prying
puja135714923p_uj_a
puna65331653p__una
puranas9712643pura_nas
pyjama20303483pyjama
pyran10514473pyra_n_
pyrans11411063pyra_ns
raga55930813_ra_ga
raia46638383_ra_ia
rain46251733_rain_
rains55140233_rains
rainy85921083_rainy
raita54623073_raita
raj105740223_raj__
rajah155711423_rajah
rajas127317723_rajas
rajes125022783_rajes
ramona8412413_ramona
ran38266623_ra_n_
rand55839573_ra_nd
rang56939173_ra_ng
rani46640113_ra_ni
rank85135533_ra_nk
rant45864683_ra_nt
ratan53722663_ratan
raya75224823_ra_ya
regna64614813_regna
ruana5312423_ruana
sauna54117553_sauna
sprain83614863sprain_
sprains93013593sprains
sprang95713523spra_ng
sradha1085333sradha
train56529113train_
trains64725343trains
trank96222423tra_nk
tranny94210863tranny
tranq145416893tra_nq
trans54933043tra_ns
trapan82412973trapan
trauma838803trauma
trona54118953tr_ona
urania62516123urania
varna84516173_varna
wrang94716113wra_ng

Search took 7 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.376475242.0
2DLD Change Limit1127162405.53020382.6
3Display Results2402400.0763157.9
 (SQL Overall)1786912405.98229871.4
 
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.