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 “scarcesu” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
scarcest12169171scarcest
scarce104013632scarce__
scarcely1534312scarcely
scarcer113911372scarce_r
scares85033002scar_es_
scariest101615952scariest
scarless10189052scarless
scarves124511622scarves_
calces104420053_calces_
carcase11312743_carcase
carcass11310513_carcass
carcel105018673_carce_l
carcels114516063_carcels
cares77369183_car_es_
caress85720263_car_ess
carices114220953_carices_
caries85147623_caries_
carles85435083_carles_
carless95118493_carless
carses85233653_carses_
cartes86239473_cartes_
carves115128453_carves_
ecartes94212563ecartes_
farces115223323_farces_
saices84221803s_aices_
sarcasm1136693s_arcasm
sarcous9312933s_arcous
sarees65329943s_arees_
sarges75128593s_arges_
sauces84919503s_auces_
scabies11613333scabies_
scales84529313sca_les_
scaliest101714403scaliest
scantest101710183scantest
scapes105122263sca_pes_
scarabs1137293scarabs_
scarceness1444763scarceness
scarcity1545093scarcity
scare75334463scar_e__
scared95227293scar_e_d
scaredest1246633scaredest
scarer84524613scar_e_r
scarers94618513scar_ers
scarey115016983scar_e_y
scarfed134711183scarfe_d
scarfer124511083scarfe_r
scarfers13408463scarfers
scarfs114714683scar_fs_
scarier94017873scarie_r
scariness11310183scariness
scariose1037593scariose
scarious10610203scarious
scarlet91516943scarle_t
scarlets10178573scarlets
scarped124314403scarpe_d
scarper114814823scarpe_r
scarpers124712513scarpers
scarphs14437413scarphs_
scarps104718603scar_ps_
scarred104512633scarre_d
scarriest11188403scarriest
scars75433533scar__s_
scarted104816123scarte_d
scarts85321493scar_ts_
scathes124515713scathes_
sconces113811453sconces_
scorches15189153scorches_
scores84725923scor_es_
scrapes116217663scrapes_
screes85023973sc_rees_
scries85226823sc_ries_
seances93015343seances_
searches132112903searches_
searest73322023sear_est
shares95236413shar_es_
sharpest1339153sharpest
smartest10310183smartest
snares65329033snar_es_
sources9312173sources_
spaces104722633spa_ces_
spares84834553spar_es_
sparest94616433spar_est
sparges104016343sparges_
sparsest1048823sparsest
stances93715963stances_
starches131912913starches_
stares66038753star_es_
starkest1239723starkest
starless81610843starless
starves104614553starves_

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 Filter1786911461620.406440125.6
2DLD Change Limit146162907.20320291.8
3Display Results90900.0332727.3
 (SQL Overall)178691907.64223382.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.