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

86 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
ideality124715(None) 
duality1147972_duality
fidelity1544932fide_lity
idealise938052idealise
idealism1147012idealism
idealist9310652idealist
idealists1047222idealists
idealize1847872idealize
ideally1137792ideal_ly
idealogy1342942idealogy
identity1245372identity
irreality1245412irreality
lineality1246422lineality
reality10313572_reality
anality10313633_anality
aurality1139223aurality
axiality1856763axiality
banality1338763banality
bipedality1852783bipedality
coevality1745383coevality
dealate83617843_dealate
dealing94323233_dealing
dealt65234283_deal_t_
debility1448643_debility
deity94316773_de__ity
density1137593_density
dentality1348473_dentality
edacity1336373ed_acity
equality2046993equality
fatality1438443fatality
fealty122910223_feal_ty
finality1448343finality
hideosity1643323hideosity
ideal65716393ideal___
idealess935653idealess
idealised1145673idealised
idealises1047783idealises
idealisms1246443idealisms
idealistic1344703idealistic
idealities1148783idealities
idealized2046653idealized
idealizer1945473idealizer
idealizes1947393idealizes
ideals75012503ideal__s
ideate7313683idea__te
ideating10311703ideating
ideation9310493ideation
ideative1238573ideative
identify1544133identify
ideology1345653ideology
idoneity1243013idoneity
illegality1473223illegality
imparity1546783imparity
inanity1039503i_nanity
indemnity1543493indemnity
inequality2254573inequality
inequity2044553inequity
insanity1147343insanity
lealty92910603_leal_ty
legality1237623legality
liberality1545903liberality
linearity1246113linearity
literality1346903literality
locality13148433locality
modality14117653modality
molality13118363molality
morality131110333morality
nasality1146653nasality
natality1139193natality
nodality12127423nodality
orality101111683_orality
ovality1377593_ovality
penality13310713penality
quality1938563_quality
realty92713693_real_ty
regality1249313regality
rurality1137403rurality
sedulity1245843sedulity
sodality12127323sodality
tonality1139793tonality
totality1139373totality
unreality1246323unreality
venality1438683venality
visuality1545453visuality
vitality1458113vitality
vocality16137933vocality

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.450397091.1
2DLD Change Limit146162867.72018932.9
3Display Results86860.0332606.1
 (SQL Overall)178691868.20321783.6
 
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.