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

174 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
proband12271024(None) 
probands13228391probands
probang12278381probang
roband92310721_roband
armband1265982armband
browband1643882browband
prebend12319442prebend
prebind123810642prebind
probangs13256212probangs
probate11414482probate
probated13410862probated
probed114114822prob_ed
probing123314442probing
profane122111862profane
profaned14207972profaned
prolan8414692prolan_
prolans9314272prolans
propane112716152propane
propend123311272propend
protend104012792protend
riband9239622_riband
robands10219862_robands
troland837542troland
armbands1355143armbands
around72712413aro_und
band76740913___band
brand85124493br__and
brigand1136643brigand
broad84817693bro_a_d
broadband1543023broadband
brogan9311043brogan_
brogans1049663brogans
browbands1743403browbands
corban10314693corban_
corbans11313173corbans
cropland1346303cropland
cryobank1942583cryobank
deodand1035713deodand
disband1138243disband
dromond1135473dromond
drownd11478313dro_wnd
dryland1254303dryland
errand758793er_rand
forbad122710503forba_d
frond95316343fro__nd
froward1436673froward
goban84414073_goban_
gobang10376703_gobang
gobans94412043_gobans
gormand1157453gormand
grand75122693gr__and
groan65618423gro_an_
groaned9259973gro_aned
groans74815063gro_ans
ground82310273gro_und
hatband1346823hatband
husband1345653husband
norland837163norland
orotund844063orotund
parkland1545373parkland
passband1344773passband
piebald1245503piebald
plowland1442743plowland
poblano1145093p_oblano
poind84217913p_o_ind
pond75530493p_o__nd
portend103411193portend
pound84417863p_o_und
prang84820323pr__ang
prank115019453pr__ank
prebade12310283prebade
prebake1539093prebake
prebaked1737173prebaked
prebends13347883prebends
prebid113512843preb_id
prebinds13357733prebinds
preboard1338263preboard
prebound1345893prebound
prefund1335733prefund
preman104117453preman_
prepaid12310133prepaid
pretend104011013pretend
proa66229963pro_a__
proas75028803pro_a_s
probable1439053probable
probably1746413probably
probates12414283probates
probating14311193probating
probe94320813prob__e
prober104516073prob_er
probers113514583probers
probes104119453prob_es
probit103218353prob_it
probits112712573probits
probity14299683probity
problem1335983problem
procaine12312273procaine
procarp1346823procarp
proceed12310553proceed
prod76129503pro___d
prodded1257733prodded
profaner13197943profaner
profanes132311573profanes
profound1444923profound
progeny1389463progeny
progged12409803progged
progun968783progun_
prolate9419793prolate
proline92321593proline
prolong10319633prolong
promine112819443promine
promoed12310083promoed
pronate9418873pronate
pronated11414053pronated
prone75332623pro__ne
prong85218113pro__ng
pronged113912393pronged
proofed13138723proofed
propanes122415823propanes
propends13249173propends
propene112716043propene
propine113020213propine
propined133111503propined
propman1339063propman_
propone112716303propone
proponed132412033proponed
propound1346393propound
propped113311953propped
prorate9418733prorate
prorated11513713prorated
prosaic11311163prosaic
prosed94921093pro_sed
prosing103319383prosing
protean92412193protean_
proteans102811543proteans
proteid103513673proteid
protends113010353protends
proton84318893proton_
protons93118003protons
proud84615483pro__ud
proved125016033pro_ved
proven114314773proven_
proving134214073proving
prowar114110943prowa_r
prowled13309913prowled
rand55839573_r__and
rebind94416933_rebind
reland75920433_reland
remand95618963_remand
repand95316063_repand
ribald9209293_ribald
ribands10208393_ribands
ribband1245583ribband
road56332113_ro_a_d
roan47234203_ro_an_
roans54926443_ro_ans
robalo838933_robalo
robbed113415193_robbed
robed85323733_rob_ed
robin74820283_robin_
robing93618003_robing
robins83617453_robins
roman75424823_roman_
romano84912943_romano
romans84620243_romans
rotund737293_rotund
round64318433_ro_und
rowan85418733_rowan_
rowans95715343_rowans
saraband1146193saraband
soland75115043_soland
trolands936423trolands
urban72013863ur_ban_
urbane82211383ur_bane

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.423422437.4
2DLD Change Limit1340271747.12318816.1
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.60923484.2
 
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.