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

46 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
logicalness145324(None) 
illogicalness1662142illogicalness
localness1145232lo__calness
logicalnesses1653192logicalnesses
logicless1242522logic_l_ess
lyricalness1653012lyricalness
ethicalness1653363ethicalness
finicalness1653613finicalness
ironicalness1463083ironicalness
loginess9310163logi___ness
poeticalness1653453poeticalness
radicalness1454583radicalness
typicalness1852573typicalness
vocalness1444393vo__calness
colonialness1453464coloni_alness
cordialness1444764cordialness
criticalness1653504criticalness
dogmaticalness2071514dogmaticalness
floricanes1544844florica_ne_s
formalness1544834fo_rmalness
illogicalnesses1871664illogicalnesses
liberalness1354514liberalness
licitness1145374l__icitness
literalness1145494literalness
locales93715094lo__cal_e_s
localises111411464lo__calises
localnesses1345854lo__calnesses
lodicules1243364lodicul_e_s
logical1038514logical____
logicalities1555054logicalities
logicality1644184logical_ity
logically1548974logical__ly
logicians1244174logician__s
logicises1256204logic_ise_s
logicizes2145934logic_ize_s
loricates11310124lorica_te_s
lovingness1443184lovi_ngness
lyricalnesses1853104lyricalnesses
ovalness1134674_o__valness
physicalness2272694physicalness
regalness1045474reg__alness
specialness1554054specialness
venialness1344604veni_alness
verticalness1754214verticalness
vitalness1245414__vitalness
voiceless1444224vo_icel_ess

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.1531167915.0
2DLD Change Limit148819469.39315843.6
3Display Results46460.0301533.3
 (SQL Overall)178691469.57618660.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.