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

119 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
comparers1531938(None) 
comparer143611361comparer_
compares143816431compare_s
comakers16339162com_akers
combaters1538092combaters
compacters18247012compacters
compadres16266412compadre_s
compare135814992compare__
compared153811822compare_d
comparts144210832compar_ts
compeers143410012comp_eers
comperes143217972compere_s
compilers1537052compilers
compliers1538292compliers
composers153910612composers
compress1439052comp_ress
computers15339732computers
bombarders17153193bombarders
campers134220283camp__ers
camporees1546103camporees
caperers122611723c_aperers
capmakers1944713capmakers
carers85133953c___arers
cellarers11236493cellarers
chompers17369573chomp__ers
clearers10349293c_learers
coalers94419333co__alers
coaters93525773co__aters
coaxers164311063co__axers
coherers132310733co_herers
coleaders1237803coleaders
collarets11327333collarets
colorers10312183co_lorers
colourers1136473colourers
comaker153410603com_aker_
comakes154413643com_ake_s
comanagers1543833comanagers
comates114123633com_ate_s
combater1439373combater_
combers134516613com__bers
combiners15247943combiners
comembers1744223comembers
comers105328083com___ers
comethers1637433comethers
comforters17275193comforters
comfreys1843333com_freys
commanders17146683commanders
commoners15339783commoners
communers15338403communers
commuters15378883commuters
compacter17257883compacter_
compactors18256253compactors
compacts16368903compa_cts
compadre15295883compa_dre
companies15311793companies
comparators1785683comparators
comparing162410583comparing
compart134016003compa__rt
comparted16338423comparted
compas125817063compa___s
compass13379563compa__ss
compasses1547393compasses
compeer133811553comp_eer_
compellers1645193compellers
compels133210883comp__els
compere134616623comp__ere
compered153414923compere_d
competes144117243compete_s
compiler1438373compiler_
compiles14311983compile_s
complainers1744473complainers
completers16298323completers
complier14310253complier_
complies14314523complie_s
comports143411983compor_ts
composer145012953composer_
composes145017113compose_s
composters16388313composters
compotes144716513compote_s
compradors1743773compradors
computer144511503computer_
computes143914533compute_s
comradery1793493comradery
comrades13149773comrade_s
conjurers18126223conjurers
conspirers1444573conspirers
coopers114019483coop__ers
coparent12412253co_parent
coparents1347973co_parents
copartners1443573co_partners
copers104629843co_p__ers
copiers114215963co_p_iers
coppers133519753co_p_pers
copters113621273co_p_ters
corers85231073co___rers
cottagers12305373cottagers
couplers123311313coup_lers
coverers132712123co_verers
cumberers15175993cumberers
cymbalers1842833cymbalers
empalers12226743_empalers
hamperers16287523hamperers
homagers1486823hom_agers
impairers1343713_impairers
impalers12226963_impalers
imparters13276563_imparters
pamperers15236863pamperers
parers85530743___parers
preparers13197673preparers
rampagers1443863rampagers
roarers73812733ro__arers
rompers113412243romp__ers
scamperers1643473scamperers
simperers1335933simperers
smearers10308623_smearers
soarers74118093so__arers
sparers94519613__sparers
tamperers13227313tamperers
temperers13247023temperers

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.1731032896.0
2DLD Change Limit1486411197.57619620.0
3Display Results1191190.0631888.9
 (SQL Overall)1786911197.81222873.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.