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 “cosine” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
cosine8382351(None) 
conine84528551conine
cosie74728261cosi_e
cosines94122671cosines
eosine64519411eosine
arsine64021042arsine
bovine11712432bovine
canine83826702canine
casing94829102casing
casini84615862casini
casino84317552casino
cassine93817282cassine
chaine115119222chaine
chine105231722c_hine
choline122915382choline
chopine143512262chopine
chorine123218362chorine
cine66242942c__ine
cline76428532c_line
closing103114842closing
cocaine111315172cocaine
codeine103815032codeine
coding104024792coding
coesite9713622coesite
cohune1189422cohune
coigne94612192coigne
coin66645352co_in_
coined94523602co_ined
coiner84323782co_iner
coins75834552co_ins
coking134523882coking
colin76231692colin_
colins85229042colins
colone85425002colone
combine133014722combine
coming114225452coming
cone67256962co__ne
confine12315582confine
coniine9316802coniine
conin76232722conin_
conines93827792conines
coning94331822coning
conins84327232conins
cooing94024922cooing
coping113927662coping
coring94433962coring
corvine122113642corvine
coshing134316432coshing
cosied94819882cosied
cosier84423752cosier
cosies84932152cosies
cosign958782cosign
cosigned1235722cosigned
cosigner1135952cosigner
cosigns1047512cosigns
cosily113613852cosily
cosiness103214282cosiness
costae85319682costae
costing104323022costing
costive12312842costive
cosying134513132cosying
coting94629252coting
cousin8517162cousin_
cousins9516002cousins
covin105621122covin_
coving124321522coving
covins114618062covins
cowing124526322cowing
coxing164218862coxing
coying124021482coying
cozie163519132cozi_e
crocine11314152crocine
cuisine9310422cuisine
cystine1239332cystine
cytosine1346872cytosine
domine92918252domine
dosing83920272dosing
eosin55220922eosin_
eosines73718292eosines
eosins64419162eosins
hosing103421102hosing
inosine7314282inosine
iodine74618652iodine
koine9516482ko_ine
losing74022872losing
lysine94210552lysine
moline84422032moline
nosing73419842nosing
opine77422462_opine
oscine8311562_oscine
ovine86316642_ovine
posing93922642posing
rosin55325312rosin_
rosined84911902rosined
rosing73925592rosing
rosins64521862rosins
rosiny94414532rosiny
rusine63916592rusine
sine46560622__sine
sozine15712352sozine
toxine133114122toxine
ursine64114122ursine

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825511022.51632810.4
3Display Results1021020.0303400.0
 (SQL Overall)1786911022.87262218.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.