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

115 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
profilers1423629(None) 
profiler13287641profiler_
profiles133211231profile_s
profiters14228311profiters
broilers103210092bro_ilers
prefiles133113442prefile_s
profaners14256212profaners
proffers16126592prof_fers
profile123211152profile__
profiled14338522profile_d
profiteers15213692profiteers
profiter132710202profiter_
profitless1542762profitless
promisers13268202promisers
providers1535592providers
prowlers13328932pro_wlers
boilers93417063_bo_ilers
broiders114211193bro_iders
broiler92911753bro_iler_
coilers93619903_co_ilers
crofters13358903crof_ters
crosiers103312063crosi_ers
croziers19287003crozi_ers
defilers12439473_defilers
filers94623723___filers
grovelers13305163grovelers
growlers12327093gro_wlers
moilers93615203_mo_ilers
oilers64721193__o_ilers
pencilers1345643pencilers
peoplers1237163peo_plers
poisers94214433p_o_isers
polers84225643p_o__lers
policers12259993p_olicers
pollers93420023p_o_llers
poofters1336923poof_ters
poolers94217423p_o_olers
praisers103410833pr_aisers
prattlers11195323prattlers
prefacers1636293prefacers
prefers123713333pref__ers
prefile123413183prefile__
prefiled143310573prefile_d
prefires134313283prefire_s
prefixes20389233prefixe_s
premiers122911653premi_ers
presiders1248213presiders
prevailers15123833prevailers
pricers113915063pr__icers
priers84521193pr__i_ers
primers114215673pr__imers
prizers183911843pr__izers
probers113514583pro__bers
problems1434343pro_blems
procurers1345033procurers
prodders1237463pro_dders
producers1454883producers
profaner13197943profaner_
profanes132311573profane_s
profess1237713prof__ess
proffer15126933prof_fer_
profferers1842423profferers
profiling1548233profiling
profilings1653563profilings
profited14279973profite_d
profiteer14274493profiteer
profits122911243profi__ts
proggers12258163pro_ggers
prolegs10379993pro__legs
proles84627203pro__le_s
prolines102619693proline_s
promines123018803promine_s
promisees13246863promisees
promiser122510673promiser_
promises122916763promise_s
promisors13236363promisors
promoters13310093promoters
prompters1537553prompters
proofers13118363pro_ofers
propellers1455203propellers
propers113619033pro__pers
propines122618933propine_s
proposers13228523proposers
prosers94219643pro__sers
prosier93817483prosi_er_
prosiness11311683prosiness
prospers123012263pro_spers
protyles13249833protyle_s
provers123817793pro__vers
provider1436703provider_
provides1439883provide_s
provokers1894203provokers
prowler123310013pro_wler_
proxies163014933proxi_e_s
purflers13216963purf_lers
purifiers1435873purifi_ers
rafflers14317363_rafflers
railers74420663_r_ailers
refiles104122423_refile_s
refilters1236103_refilters
refiners114713313_refiners
revilers114011693_revilers
rifflers14336443_rifflers
riflers103512193_rif_lers
rollers73117473_ro_llers
rotifers1136043_rotifers
rufflers14347193_rufflers
spoilers10238633spo_ilers
toilers74116263_to_ilers
trailers82912923tr_ailers
triflers113110213trif_lers
troffers14125433trof_fers
trollers83211213tro_llers
troublers1135003troublers
trowelers12105263trowelers

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.470380193.6
2DLD Change Limit1486411157.36020195.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.87622688.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.