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

52 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
colloquists225300(None) 
colloquist2154211colloquist_
colloquials2252392colloquials
colloquies2144092colloqui_es
colloquiums2452082colloquiums
soliloquists2162382soliloquists
collagists1345263coll_agists
colloquia2053393colloqui__a
colloquial2153073colloqui_al
colloquium2352533colloqui_um
colonists112512503co_lo_nists
colorists112313593co_lo_rists
soliloquises2182333soliloquises
soliloquist2062973soliloquist_
balloonists1353024balloonists
callouses1147684callo_u_ses
cellists1038564cell___ists
collagist1248024coll_agist_
collodions1344594collo_dions
collogues1246214collogu__es
colloguing1444554collogui_ng
colloids11310174collo__i_ds
colloquialism2672064colloquialism
colloquialisms2771764colloquialisms
colloquiality2761764colloquiality
colloquially2691964colloquially
colloquy2243034colloqu___y
colobuses1346134co_lobu_ses
colonises112814014co_lo_nises
colonist102617934co_lo_nist_
colorcasts1444244co_lorcasts
colorisms132810794co_lo_risms
colorist102818994co_lo_rist_
columnists1444364co_lumnists
conformists1854184conformists
conquests2045364co__nquests
ecologists13310924eco_lo_gists
folklorists18111774folklo_rists
monologuists1553954monologuists
obloquies2042774_obloqui_es
ologists939444_o_lo_gists
oologists1039854_oolo_gists
pollists10910824poll___ists
poloists10910524po_lo__ists
rollouts8136734rollo_u__ts
soliloquies2072534soliloqui_es
soliloquise2082404soliloquis_e
soliloquised2271884soliloquised
soliloquizes3061824soliloquizes
soloists869154so_lo__ists
syllogists14175174syllo_gists
zoologists2047174zoolo_gists

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 Filter1786911488190.436409841.7
2DLD Change Limit148819528.17318208.6
3Display Results52520.0301733.3
 (SQL Overall)178691528.63920684.2
 
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.