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

84 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
coassist1029880(None) 
classist104010381classist
coassists11275761coassists
assist6314602__assist
bassist9312742_bassist
cassis84818852c_assis_
casuist9411302c_asuist
chassis123910662chassis_
classiest11309542classiest
classis93712722classis_
classism12407172classism
classists11296242classists
coarsest1039162coarsest
coassisted1343292coassisted
consist9316032co_nsist
cosmist11311332co_smist
crassest103411522crassest
assists738473__assists
bassists1037183_bassists
bossiest103112213bo_ssiest
bossism1136063bo_ssism
brassiest11369713brassiest
brassish1346433brassish
cambist13312113c_ambist
cassia83714763c_assi_a
cassias93514343c_assias
cassina94113163c_assina
cassine93817283c_assine
cassino93512433c_assino
cassises103811743c_assises
casuists1036523c_asuists
chartist131112133chartist
chasses124017503chasses_
chastest1349703chastest
chastise1348173chastise
cladist10311963cla_dist
classes94717943classes_
classic113710113classi_c
classicist1445603classicist
classico12386303classico
classics12418873classics
classier10359083classier
classify1644693classify
classily1336623classily
classing113211793classing
classisms13295523classisms
coadmit1247823coadmi_t
coadmits1345703coadmits
coalfish1635493coalfish
coaliest10316223coaliest
coalpit1148503coalpi_t
coalpits1245393coalpits
coassisting1443583coassisting
coassume12103963coassume
coast75236263coa___st
coasting113615503coasting
coasts85719133coa_sts_
coastwise1463013coastwise
coatis85122593coa_tis_
coattest1038853coattest
coexist1638583co_exist
colonist102617923colonist
colorist102818993colorist
consists10310593co_nsists
copyist1439053co_pyist
cosiest93819853co_siest
cosmism1337013co_smism
cosmists1237993co_smists
cosset84125863co_ss_et
cossets95014283co_ssets
crasis85020473cra_sis_
crossest1012012123crossest
czarist18710223cza_rist
fascist1239213_fascist
gassiest93212523_gassiest
glassiest10279243glassiest
grassiest10309513grassiest
hoarsest1137133hoarsest
lassis65216703_lassis_
massiest103314423_massiest
mossiest103112443mo_ssiest
oasis56422553_oa_sis_
sassiest83413613_sassiest
toastiest937423toastiest

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.1531167915.0
2DLD Change Limit146162848.19017846.4
3Display Results84840.0302800.0
 (SQL Overall)178691848.37321341.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.