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

91 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
idealists104722(None) 
idealises1047781idealises
idealisms1246441idealisms
idealist9310651idealist_
delists84414172_de_lists
dialists9411412_dialists
dualists958242_dualists
idealess935652ideales_s
idealise938052idealis_e
idealised1145672idealised
idealism1147012idealis_m
idealistic1344702idealistic
ideality1247152ideali_ty
idealizes1947392idealizes
idylists1244122id_ylists
idyllists1342442idyllists
medalists1249372medalists
realists83014842_realists
annalists949063annalists
arbalists1148483arbalists
cabalists1339153cabalists
cellists1038563_cellists
deadlifts1443023_deadlifts
dealings103510703_dealings
deists74916433_de__ists
delicts104012253_de_licts
delist74625053_de_list_
dentists939263_dentists
desists83611723_de_sists
dialist8517763_dialist_
diallists1056003diallists
diarists9410363_diarists
digamists1345003digamists
dualisms1147213_dualisms
dualist8614053_dualist_
duelists966003_duelists
duellists1053753duellists
enlists749393__enlists
fatalists12310023fatalists
federalists1544753federalists
fideists1245543fide__ists
fidelista1343203fide_lista
fidelistas1451873fide_listas
finalists123010163finalists
fiscalists1544673fiscalists
idealising1245703idealising
idealities1148783idealities
idealize1847873ideali_ze
idealized2046653idealized
idealizer1945473idealizer
idealizers2043703idealizers
idealless1042953idealless
ideals75012503ideal___s
ideations1039903ideations
ideologists1346653ideologists
idolises938763id_olises
idolisms1146353id_olisms
idylist1146653id_ylist_
idyllist1243963idyllist_
imagists1175113i_magists
kabalists1546293kabalists
legalists1047943legalists
libelists1146953libe_lists
liberalists1346403liberalists
literalists1148073literalists
localists11149793localists
loyalists12137473loyalists
medalist11414213medalist_
medallists1344363medallists
metalists11412663metalists
midlists1137523mid__lists
modelists1246473mode_lists
moralists11311103moralists
muralists1148163muralists
niellists944793niellists
odalisks1363503od_alisks
oralists8611803_oralists
realises82420183_realises
realisms102212163_realisms
realist73225383_realist_
reenlists946263reenlists
relists73817053_re_lists
ritualists1046173ritualists
royalists12178113royalists
ruralists947643ruralists
sealifts1135473_sealifts
sodalists1038153sodalists
totalists9310753totalists
visualists1344893visualists
vitalists1239223vitalists
vocalists14108893vocalists

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 Filter1786911486410.453394461.4
2DLD Change Limit148641917.67319372.0
3Display Results91910.0461978.3
 (SQL Overall)178691918.17221866.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.