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

60 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
troilism104719(None) 
troilisms1146411troilisms
troilite849542troilite
troilus736412troilus_
tropism1139292tro_pism
atropism1247993atro_pism
broiling113112013broiling
broils84114173broil_s_
brominism1545353brominism
bromism1337623bro_mism
cronyism1544723cronyism
druidism1253463druidism
eroticism13219183eroticism
erotism9312303ero_tism
familism1546343familism
heroinism1446873heroinism
holism113713753_ho_lism
idolism1037273ido_lism
moralism12312363moralism
nihilism1345193nihilism
oralism9513763or_alism
prosaism1268043prosaism
pugilism13144683pugilism
realism93115923_realism
roilier7311523_roilier
roiliest8312283_roiliest
roiling83220453_roiling
roils54826793_roil_s_
royalism13128473_royalism
sciolism1247093sciolism
stoicism1246873stoicism
toiles63923513t_oiles_
toiling83219023t_oiling
toils54527493t_oil_s_
totalism10311093totalism
tourism939423t_ourism
trailing92916093trailing
trails64622513trail_s_
trellis739873trellis_
triadism1147553triadism
tribalism1347893tribalism
trilith10310513tr_ilith
trillium1046203trillium
trills64319853tr_ills_
triols66117803triol_s_
tritium969013tr_itium
trivium1256143tr_ivium
troikas1135033troikas_
troilites948433troilites
troiluses944553troiluses
trois57226093tro__is_
trollied935893trollied
trollies8310233trollies
trolling93212493trolling
trolls64613943tro_lls_
tropisms1247723tro_pisms
trotline8310023trotline
truism8118623tr__uism
virilism1347273virilism
wholism1535883who_lism

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.420425454.8
2DLD Change Limit146162607.55019359.2
3Display Results60600.0134615.4
 (SQL Overall)178691607.98322383.9
 
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.