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

43 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
zapateos194311(None) 
zapateo1844591zapateo_
zapateados225872zapateados
abaters95115203_abaters
abates85825043_abate_s
agates76121343_agate_s
alates64833973_alate_s
anattos7138453_anattos
aparejos17123293_aparejos
calathos1347533calathos
capotes11314643capote_s
carates95630613carate_s
galateas937153galateas
hamates122917683hamate_s
hapaxes1936593hapaxe_s
haptens124511343hap_tens
karates115617473karate_s
malates93522613malate_s
manatees10310423manatees
palates93624943palate_s
palpates122613063palpate_s
pareos87023773__pareos
paseos88015813__paseos
patens84820863__patens
paters84935843__paters
pates76047893__pate_s
pathos115516693__pathos
patios85221793__patios
pupates113311433pupate_s
rabatos93010913rabat_os
sapotes9313943sapote_s
savates10312953savate_s
spates85028173_spate_s
tapaderos1242373tapaderos
tapalos938813tapa_los
tapsters10318803tapsters
vacates12312833vacate_s
zacaton1845633zacat_on
zacatons1945703zacatons
zamarros1942683zamarros
zapateado2151153zapateado
zappers203911633zap_pers
zaptiehs2241863zaptiehs

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.423422437.4
2DLD Change Limit146162436.78021557.8
3Display Results43430.0162687.5
 (SQL Overall)178691437.21924752.9
 
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.