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

146 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
profiters1422831(None) 
profilers14236291profilers
profiteers15213691profiteers
profiter132710201profiter_
crofters13358902crof_ters
poofters1336922poof_ters
profaners14256212profaners
proffers16126592prof_fers
profiler13287642profiler_
profiles133211232profile_s
profited14279972profite_d
profiteer14274492profiteer
profitless1542762profitless
profits122911242profit__s
promisers13268202promisers
promoters13310092promoters
prompters1537552prompters
providers1535592providers
arbiters1038853ar_biters
broiders114211193bro_iders
broilers103210093bro_ilers
bruiters10329143br_uiters
crafters13419953craf_ters
crofter12299573crof_ter_
crosiers103312063crosi_ers
croziers19287003crozi_ers
drafters12338523draf_ters
drifters12417913drif_ters
forfeiters1643783forfeiters
frontiers1254993frontiers
fruiters11328183fr_uiters
goiters84014443_go_iters
grafters12409193graf_ters
grifters12389233grif_ters
grouters95910083gro_uters
lofters103912903_lof_ters
loiters74116613_lo_iters
orbiters1036593or_biters
orometers11310423orometers
plaiters103512633p_laiters
plotters104011553plo_tters
podites103014733p_odite_s
pointers103013723p_ointers
poisers94214433p_o_isers
policers12259993p_olicers
politer92417073p_oliter_
poofter1237163poof_ter_
porters93722703p_o_rters
posters93928013p_o_sters
potters94024343p_o_tters
poulters103911053p_oulters
pouters94221873p_o_uters
powters124015663p_o_wters
praisers103410833pr_aisers
praters94921653pr__aters
prealters1147773prealters
prefacers1636293prefacers
prefers123713333pref__ers
prefiles133113443prefile_s
prefires134313283prefire_s
prefixes20389233prefixe_s
premiers122911653premi_ers
presiders1248213presiders
presters103419003pr_esters
pricers113915063pr__icers
priers84521193pr__i_ers
primers114215673pr__imers
printers103214903pr_inters
prizers183911843pr__izers
probates12414283probate_s
probers113514583pro__bers
probities13312653probities
probits112712573probit__s
proctors12311513pro_ctors
procurers1345033procurers
prodders1237463pro_dders
producers1454883producers
proettes10312763proette_s
profaner13197943profaner_
profanes132311573profane_s
profess1237713prof__ess
proffer15126933prof_fer_
profferers1842423profferers
profile123211153profile__
profiled14338523profile_d
profit113016273profit___
profiteered1751493profiteered
profiterole1651683profiterole
profiteroles1751353profiteroles
profiting1549983profiting
profitwise1852093profitwise
proggers12258163pro_ggers
prolines102619693proline_s
promines123018803promine_s
promisees13246863promisees
promiser122510673promiser_
promises122916763promise_s
promisors13236363promisors
promoter12311453promoter_
promotes12314123promote_s
prompter1437983prompter_
pronates10418373pronate_s
pronators11411303pronators
proofers13118363pro_ofers
propers113619033pro__pers
propines122618933propine_s
proposers13228523proposers
prorates10418073prorate_s
prosateurs1243063prosateurs
prosers94219643pro__sers
prosier93817483prosi_er_
prosiness11311683prosiness
prospers123012263pro_spers
prosties101421193prostie_s
proteas92015123pro__teas
protecters14168253protecters
protesters12169383protesters
proteus92511593pro__teus
provers123817793pro__vers
provider1436703provider_
provides1439883provide_s
provokers1894203provokers
prowlers13328933pro_wlers
proxies163014933proxi_e_s
purifiers1435873purifi_ers
pyrometers1748333pyrometers
rafters103715633_raf_ters
reciters102613113_reciters
refilters1236103_refilters
refiners114713313_refiners
refuters11449613_refuters
roasters83615933_roasters
roisters83615553_roisters
roosters83514663_roosters
rooters74522933_ro_oters
rosters73727543_ro_sters
rotifers1136043_rotifers
rotters74421393_ro_tters
rousters84315683_rousters
routers74822873_ro_uters
roysters113610533_roysters
troffers14125433trof_fers
trotters83310243tro_tters
uprooters1164253upro_oters
vomiters1337203_vomiters
writers105513493wr__iters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411466.51322822.2
3Display Results1461460.0632317.5
 (SQL Overall)1786911466.99925530.9
 
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.