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

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

44 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
colloquiality276176(None) 
colloquialism2672062colloquialism
colloquially2691942colloquial_ly
collegiality1863223coll_egiality
colloquial2153073colloquial___
colloquialisms2771763colloquialisms
colloquialities2671883colloquialities
colloquials2252393colloquial__s
coequality2454264co__equ_ality
collaterality1862554collaterality
colloquia2053394colloquia____
colloquist2154214colloqui__st_
colloquists2253004colloqui__sts
cellularity1652565cell__ularity
coilability1847925coil_abi_lity
collapsibility2361945collapsibility
collectivity2254235collecti_vity
collegially1753405coll_egial_ly
collinearity1762195coll_inearity
colloidally1752645collo_idal_ly
colloquies2144095colloqu___ies
colloquium2352535colloqu___ium
colloquiums2452085colloqui__ums
colloquy2243035colloqu_____y
colonialism1565435co_lo_nialism
colonialist1376725co_lo_nialist
colonialists1484995co_lo_nialists
colonialize2254625co_lo_nialize
colonially1546685co_lo_nial_ly
commerciality2463385commerciality
commonality2055535commo__nality
communality2055175co__mmunality
congeniality1854595co_ngeniality
conjugality2452555co__njugality
connaturality1872475connaturality
connubiality1952385co_nnubiality
conviviality2352515co_nviviality
cordiality1645615c___ordiality
corporality1854655corpo__rality
corporeality1963045corpo_reality
illiquidity2461215_illiqui_dity
illogicality1862175_illogicality
loquacity2342485___loqu_acity
obloquial2051795_obloquial___

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790449.11013698.1
3Display Results44440.0331333.3
 (SQL Overall)178691449.28319249.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.