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

130 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
parboil113832(None) 
garboil1036511garboil
parboils1237431parboils
aboil72217542_a_boil
garboils1145662garboils
panbroil1243672panbroil
parafoil1345972parafoil
parboiled1445222parboiled
parol74826272par_o_l
potboil1195462potboil
preboil1148952preboil
airfoil1044463airfoil
arbor74818113_arbo_r
arbors84717883_arbors
arbour84211333_arbour
archil11611573_archil
argil65116883_ar_gil
argol65317263_argo_l
aril45843023_ar__il
aroid65428343_ar_oid
assoil688543_assoil
babool103012153ba_bool
barbal104016663barb_al
barbel104317073barb_el
barbell11429963barbell
barbie105018353barb_ie
boil66335183___boil
broil74918223_br_oil
carbo94923843carbo__
carbolic1448323carbolic
carbon104919043carbo_n
carbonic1439993carbonic
carbons115418943carbons
carbonyl1595383carbonyl
carbora11310703carbora
carbos105122263carbo_s
carboxyl22103633carboxyl
carboy134914183carbo_y
carboys144711783carboys
carol75128613car_o_l
caroli85918233car_oli
carpool1139223carpool
charbroil1643003charbroil
corbeil11859213corbeil
embroil1146613embroil
gambol1138223gambo_l
gerbil938343gerb_il
gumboil1244373gumboil
harbor11410723harbo_r
harbors12412413harbors
harbour1247053harbour
labroid1038823labroid
overboil1336913overboil
pail66141833pa___il
panbroils1343223panbroils
parabola1246663parabola
parabolic1546283parabolic
parafoils1445513parafoils
paranoia10410573paranoia
paranoic1249833paranoic
paranoid11311143paranoid
parasail1049233parasail
parasol939553parasol
parbake1538353parbake
parboiling1545173parboiling
parcel103915473par_cel
pardi85723953par_di_
pardie96021443par_die
pardon94618733pardo_n
pardons103817623pardons
pareo74632603pareo__
pareos87023773pareo_s
paresis93315093paresis
paretic113016673paretic
parfait12312053parfait
parfocal1565393parfocal
pargo86723723pargo__
pargos95719043pargo_s
paris75145943par__is
parlor8312673parlo_r
parlors9312913parlors
parlour937263parlour
parlous9414293parlous
parodic122311723parodic
parodoi10267723parodoi_
parody12410093par_ody
parole84425253par_ole
parols84722613par_ols
parotic112518043parotic
parotid102915513parotid
parotoid11410033parotoid
parous84024163par_ous
parral85517533par_ral
parrel84515983par_rel
parrot8320663parro_t
parrots9312743parrots
parroty1247863parroty
parsnip1146323parsnip
parson83817903parso_n
parsonic1239703parsonic
parsons93516873parsons
partial92616263partial
parton84720993parto_n
partons94620513partons
partook1337313partook
parvis116114803par_vis
parvo107719183parvo__
parvolin1376933parvolin
parvos116614753parvo_s
pasquil1843923pasquil
pastil85018323pa_stil
patois84319363pa_tois
patrol83213023patro_l
payroll1245613payroll
percoid12312323percoid
peril75425953per__il
potboils1284633potboils
preboils1267293preboils
probit103218353p_robit
prowl105615123p_r_owl
purloin9107493purloin
pyrrol1136273pyrro_l
reboil83814683_reboil
reoil55321183__reoil
roil46235293__r_oil
sarcoid10310453sarcoid
sparoid102311543spar_oid
strobil936963strobil
turmoil944723turmoil
upboil1096453_upboil

Search took 9 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 Limit1340271307.86017051.8
3Display Results1301300.0462826.1
 (SQL Overall)1786911308.31221498.0
 
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.