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 “escapee” 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
escapee11331046(None) 
escape103811661escap_e
escaped12388851escaped
escapees12336331escapees
escaper11368841escaper
escapes113811671escapes
escapade1343302escapade
escapers12337412escapers
escarped1355162escarped
scape96921842_scap_e
scaped115519552_scaped
scapes105122262_scapes
ascared10399523ascared
cape87242783__cap_e
caped104931803__caped
caper94831623__caper
capes95441923__capes
ecarte84313503e_carte
elapse857523e_lapse
emcee9315943emc__ee
encage93713503enca_ge
encaged113211083encaged
encages103313783encages
encamped1535023encamped
encase83714363enca_se
encased103512313encased
encases93116053encases
epee64628503e___pee
epopee10312503e_popee
escalade1144383escalade
escalate1039323escalate
escalop1144783escalop
escalope1244523escalope
escaloped1443983escaloped
escalopes1344773escalopes
escapable1544983escapable
escapades1442993escapades
escapement1645863escapement
escaping1347063escaping
escapism1444453escapism
escapist1246213escapist
escar74011993esca__r
escarole1045743escarole
escarp10449003esca_rp
escarps11397373escarps
escars83913133esca_rs
eschew1436333esc_hew
escoted1038183escoted
escuage1035113escuage
escuages1145163escuages
essayed1134013essayed
essayer1033943essayer
estate64719763esta_te
estated83715573estated
estates74520183estates
etape74413703e_tap_e
etapes85415293e_tapes
eucaine939243eucaine
evacuee12105073evacuee
exciple1874683exciple
inscape1138023inscap_e
inscapes1237813inscapes
rescale93215473resca_le
rescaled113311303rescaled
rescales103414573rescales
reshape1249043reshap_e
reshaped1437203reshaped
reshaper1336913reshaper
reshapes1338803reshapes
saree55044663_s_aree
scale74629143_sca_le
scaled94822443_scaled
scalene9310773_scalene
scaler84321603_scaler
scales84529313_scales
scalped124411993_scalped
scalpel11377713_scalpel
scalper113912923_scalper
scamped144711963_scamped
scamper134613163_scamper
scapose1147753_scapose
scarce104013633_scarce
scare75334463_sca_re
scared95227293_scared
scarer84524613_scarer
scares85033003_scares
scarey115016983_scarey
scarped124314403_scarped
scarper114814823_scarper
scathe114414993_scathe
scauper11379453_scauper
schappe1635273_schappe
scope94821483_scop_e
scoped115116653_scoped
scopes104719593_scopes
scrape105917573_scrap_e
scraped124313133_scraped
scraper114513423_scraper
scrapes116217663_scrapes
scrapie115010943_scrapie
scree720031713_sc_ree
seascape1245173seascap_e
seascapes1344823seascapes
serape84818413serap_e
serapes95218103serapes
shape105125113_shap_e
shaped125020103_shaped
shapen114414653_shapen
shaper114119933_shaper
shapes115124953_shapes
soaped95817973_soaped
soaper84517873_soaper
spahee11313443_spahee
stapes85028733_stapes
staple84415823_staple

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271156.65620136.3
3Display Results1151150.0303833.3
 (SQL Overall)1786911157.07625253.1
 
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.