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 “messianisms” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

50 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
messianisms155339(None) 
messianism1453721messianism_
lesbianisms1552532lesbianisms
lesbianism1452603lesbianism_
mechanisms1945723me_chanisms
melanisms1348653me__lanisms
messianic1342953messiani__c
messiness11248223messi_nes_s
pessimisms1653003pessi_misms
escapisms1543944_e_scapisms
essayists1242744_ess_ayists
feminisms16217684fe_mi_nisms
fusionisms1543994_fusionisms
heroinisms1546634heroi_nisms
hessians1145054hessian___s
hispanisms1753244_hispanisms
impressionisms2062364impressionisms
jesuitisms1952364jesui_tisms
massiness112810144massi_nes_s
mechanism1846564me_chanism_
mechanists1745894me_chanists
melanism1239364me__lanism_
melanists1148624me__lanists
meliorisms1445554me_liorisms
mentalisms1449314me_ntalisms
mesmerisms1344144me_smerisms
messalines1245224mess_alines
messans92710464mess_an___s
messiahs1343964messia___hs
messinesses1297514messinesses
metricisms1646524metri_cisms
missionizes22123794missionizes
mosaicisms1644184mosai_cisms
mossiness11258324mossi_nes_s
mussiness11238304mussi_nes_s
mysticisms1944604mysti_cisms
passivisms1743714passi_visms
pessimism1553324pessi_mism_
pessimists1453864pessi_mists
pianisms1249014___pianisms
plebeianisms1862234plebeianisms
prussianises14102464prussianises
revisionisms17143874revisionisms
ruffianisms1951684ruffianisms
satanisms1148144__satanisms
secessionisms1662774secessionisms
sensualisms1353874sensualisms
serialisms12610274se_rialisms
utopianisms1552704utopianisms
veganisms1545414ve__ganisms

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819509.16016246.6
3Display Results50500.0301666.7
 (SQL Overall)178691509.61018594.3
 
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.