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

93 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
cipherer154557(None) 
ciphered1637051ciphered
cipherers1644881cipherers
caperer113013402cap_erer
cipher133710262ciph__er
ciphers14379982cipher_s
coherer122912782c_oherer
cyphered1934652cyphered
decipherer1852422decipherer
ditherer12187762ditherer
encipherer1752462encipherer
kipperer16294722kipperer
witherer14187952witherer
adherer1137563_adherer
bickerer16106773bickerer
bitterer10309773bitterer
capered123014043cap_ered
caperers122611723cap_erers
capturer1246083capturer
careerer1038583careerer
caterer92815933c_aterer
catheter1338153catheter
cheder125113493c__heder
cheer105420383c__he_er
cheerer123511753c_heerer
chewer145512613c__hewer
chippered1945003chippered
cindered1239793cindered
ciphering17217693ciphering
ciphertext2451673ciphertext
cither114616683cith__er
cithern12489913cither_n
citherns13338863citherns
cithers124315753cither_s
cithren12306593cith_ren
cleverer1334563cleverer
cohere112716993c_ohere_
cohered133514693c_ohered
coherers132310733c_oherers
coheres122917693c_oheres
coinhere1337133coinhere_
coinhered1536593coinhered
coinheres1447633coinheres
coppered153410543coppered
coshered14610293coshered
coverer123113523c_overer
cumberer14266993cumberer
cupbearer1542403cupbearer
cupeler1177483cup_eler
cypher16306593cyph__er
cyphers17316753cypher_s
dapperer1335763dapperer
deciphered1943003deciphered
decipherers1951783decipherers
diplexer1844203diplexer
dithered13189293dithered
ditherers13196683ditherers
enciphered1853193enciphered
encipherers1851623encipherers
filterer11258143filterer
fingerer12127213fingerer
gatherer12147903gatherer
hinderer1238273hinderer
inhere9313713_inhere_
inhered11313163_inhered
inheres10315173_inheres
kippered17255623kippered
kipperers17233823kipperers
latherer111310443latherer
limberer12187043limberer
lingerer9118293lingerer
lippered13287953lippered
litterer82810173litterer
miterer92511333mi_terer
paperer113111903pap_erer
pepperer1145273pepperer
pilferer1344923pilferer
ripener937903rip_ener
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
sphere113313653_sphere_
sphered133512313_sphered
spheres123114353_spheres
spherier1337783_spherier
syphered1755013syphered
taperer92511793tap_erer
tinkerer1286803tinkerer
titterer8268523titterer
winterer112110443winterer
withered15169433withered
witherers15146843witherers
zippered22244823zippered

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.1731032896.0
2DLD Change Limit146162937.65619091.2
3Display Results93930.0303100.0
 (SQL Overall)178691937.85922737.1
 
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.