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

154 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
probity1429968(None) 
probit103218351probit_
probits112712571probits
improbity1843642improbity
piosity1268642piosity
polity113015862p_olity
porosity1348592porosity
priority1347442priority
privity15268312privity
probate11414482probate
probing123314442probing
prodigy1435572prodigy
profit113016272profit_
profits122911242profits
prosily12611632prosily
prosit85124592prosit_
apriority1444743apriority
aridity11510113aridity
atrocity1347213atrocity
brevity1534783brevity
comity13312713_comity
crudity1336043crudity
droit65127123dro_it_
droits74314313dro_its
ferocity1645993ferocity
frosty124710633fro_sty
frowsty16464983frowsty
fruity12429693fr_uity
gravity1437183gravity
grotty10389833gro_tty
grouty104710983gro_uty
moronity1347333moronity
morosity1347293morosity
niobite937953niobite
obit66837083__obit_
obits74617553__obits
orality101111683orality
orbit73622063or_bit_
orbits84211443or_bits
parity114719873p_arity
paucity1435823paucity
phobia13278603phobi_a
phobias14228183phobias
phobic153010073phobi_c
phobics16286703phobics
phonily1537103phonily
pilosity1366323pilosity
pity96031933p___ity
ploidy1237483plo_idy
plotty11208853plo_tty
poboy121612223p_ob_oy
podite93315353p_odite
pointy114913283p_ointy
pokily15309063p_okily
policy133211513p_olicy
polite83625073p_olite
posit75833333p_osit_
posits85718713p_osits
potty105621003p_o_tty
pouty107018813p_o_uty
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
prebirth1543463prebirth
prebuy1357423preb_uy
precocity1845913precocity
pretty11510873pr_etty
pricily142710283pricily
pricy124814563pr__icy
privily15207623privily
privy13439833pr__ivy
probably1746413probably
proband122710243proband
probang12278383probang
probated13410863probated
probates12414283probates
probatory1647113probatory
probe94320813prob__e
probed114114823prob_ed
prober104516073prob_er
probers113514583probers
probes104119453prob_es
probingly1746013probingly
probiotic1546663probiotic
probities13312653probities
problem1335983problem
proette9312363proette
profanity1744793profanity
profile123211153profile
profited14279973profited
profiter132710203profiter
progeny1389463progeny
prohibit1547193prohibit_
prohibits1644933prohibits
projet15315183projet_
projets1639163projets
prolate9419793prolate
proline92321593proline
prolix1538683proli_x
prolixity2144863prolixity
prolixly2043113prolixly
promine112819443promine
promise113415843promise
promote11313143promote
prompt12313013prompt_
promptly1743913promptly
prompts1337473prompts
pronate9418873pronate
pronely12310253pronely
pronota939763pronota
pronto8313993pro_nto
property1547073property
propine113020213propine
propriety1645433propriety
prorate9418733prorate
prosier93817483prosier
prosing103319383prosing
prosody1336433prosody
prost75434103pro_st_
prostie91617743prostie
prosy106319253pro__sy
protist9320223protist
protists10313363protists
protium11312293protium
protyl11308213pro__tyl
proudly1336333proudly
provide1339853provide
proving134214073proving
proviso1237313proviso
proxies163014933proxies
proximity2344673proximity
proximo1845143proximo
proxy175011013pro__xy
purity114114913p_urity
rabbity14266303rabbity
rarity93615493_rarity
robin74820283_robi_n
robing93618003_robing
robins83617453_robins
robot7325973_robot_
robotry1244173_robotry
robots8313153_robots
roily86121113_ro_ily
rooty86423023_ro_oty
ropily113312443_ropily
rosily93914713_rosily
rosiny94414533_rosiny
serosity1148783serosity
sorority1146903sorority
torosity1147243torosity
trinity10310843trinity
trouty95211793tro_uty
urolith1048783urolith

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.410435831.7
2DLD Change Limit1340271546.82619634.8
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.29924481.6
 
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.