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

68 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
maestros104616(None) 
maestro945721maestro_
cabestros1343872cabestros
maelstrom1382372maelstrom
maelstroms14112292maelstroms
maestoso1053202maest_oso
maestosos1142512maestosos
maestri945482maestr_i
metros84217802m_e_tros
anestrous946603anestrous
anestrus856313anestrus
bestrow1237253_bestrow
bestrows1337043_bestrows
bistros92810983_bistros
cabestro1243683cabestro_
caesars9410733caesar_s
caestus947773caest_us
caesuras1055733caesuras
castors94919443ca_stors
cestos84718093_cest_os
destroy1138153_destroy
destroys1236693_destroys
diestrous1046603diestrous
diestrus946523diestrus
electros102811753electros
estrous7712533__estrous
estrus61912113__estrus
macros104017013ma__cros
maduros1036303ma_duros
maists85817573maist__s
majesties1845373majesties
manitos9314053manit_os
mansards1148013mansards
mantras93815863ma_ntras
masers84623453ma_ser_s
masters94628923ma_sters
mastics112614783ma_stics
masts77035763ma_st__s
matres84522233ma__tres
matron83918313ma__tron
matrons93517633ma__trons
matzos1749263ma__tzos
measures1038913measures
mentors9314993m_entors
mesotron1045383m_esotron
mesotrons1145513m_esotrons
mestees94617753m_estees
mesteso937133m_esteso
mestesos1045223m_estesos
mestinos1048163m_estinos
mestizos1944493m_estizos
metestrus1143133metestrus
metres85121563m_e_tres
metro74718803m_e_tro_
monestrous1274283monestrous
monstrous1187353monstrous
nestors73614973_nestors
oestrous869923_oestrous
oestrus7169583_oestrus
olestras846583olestras
paesanos10296703paesanos
palestras1145723palestras
pastors94119003pa_stors
pestos84719083_pest_os
prestos93716083prest_os
quaestors1843613quaestors
questors17147013questors
retros63820193_re_tros

Search took 9 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 Limit146162688.11018022.4
3Display Results68680.0302266.7
 (SQL Overall)178691688.56320867.8
 
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.