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

56 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
mentalese114632(None) 
mentaleses1245951mentaleses
mentalism13511642mentalism
mentalist11515552mentalist
metalise10416052me_talise
centals94317053cental_s_
centares102913893centares_
centiles103615813centiles_
centralest1247143centralest
centralise1269603centralise
dentals83915393dental_s_
entases72816273_entases_
gentiles93713523gentiles_
gentilesse1142543gentilesse
gentles83714343gent_les_
gentlest93410573gent_lest
legalese954753le_galese
manganese1244803manganese
mantles94820703mant_les_
meatless103410863meat_less
meltages1148243meltages_
menaces112715523men_aces_
menages103615393men_ages_
menials94015693menial_s_
menseless1145203menseless
mental84521603mental___
mentalisms1449313mentalisms
mentalists12410483mentalists
mentality1449133mentality
mentally131010403mental_ly
mentee84121293ment__e_e
mentees93214503ment_ees_
menthene1347033ment_hene
metages102714973me_tages_
metaled102913883me_tale_d
metalised12310463me_talised
metalises11315073me_talises
metalist10519353me_talist
metalize19414783me_talize
metals84520893me_tal_s_
metamere1257353me_tamere
metates92720013me_tates_
mettles94115023me_ttles_
mintages111110513mintages_
montages111412183montages_
montanes101114523montanes_
penalise101013763pen_alise
pentacles1338773pentacles_
pentanes10316083pentanes_
rentals74017473rental_s_
tantalise91210823tantalise
tentacles1146713tentacles_
tentages91011043tentages_
tentless8229843tent_less
ventages12119773ventages_
ventless11249053vent_less

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 Filter1786911486410.470380193.6
2DLD Change Limit148641567.48319863.8
3Display Results56560.0163500.0
 (SQL Overall)178691567.96922423.3
 
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.