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 “canines” 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
canines9372403(None) 
canine83826701canine_
conines93827791conines
cyanines132710541cyanines
acarines10314342acarines
alanines8314802alanines
alines65735222_alines
amines84727982_amines
animes84719592_animes
anises64826692_anises
azines155517072_azines
cabined1239992cabined
cabinet11318902cabinet
cabinets1238282cabinets
cabins104418922cabin_s
caginess11310302caginess
cains75334302ca_in_s
cajones163311332cajones
cakiness1449552cakiness
calcines12314752calcines
calices114321692calices
camises114218462camises
canapes111213082canapes
candies104125612candies
candles104422342candles
canes75350372ca__nes
cangues10611822cangues
canids95118132cani_ds
caning94128622canin_g
canities101519262canities
cannas84518402can_nas
canned95022062can_ned
cannel84216402can_nel
cannels93413362can_nels
canner84625982can_ner
canners93822662can_ners
cannie83819362cannie_
cannier94014162cannier
canniest10313362canniest
canniness1138642canniness
cannings113710332cannings
canoes84725882can_oes
canoness1039392canoness
canons85522062canon_s
cantinas102713772cantinas
cantles94721412cantles
canzones1939152canzones
capizes20410372capizes
carbines123617532carbines
caribes113715642caribes
carices114220952carices
caries85147622cari_es
carinas93622402carinas
carlines103521642carlines
carmines123617862carmines
carnies94123962carni_es
casings104013512casings
casinos93512832casinos
cassines103116612cassines
cavies114525002cavi_es
cavings134712542cavings
chaines124518732chaines
chines115029172c_hines
cines75239682c__ines
clines84926042c_lines
confines13315652confines
conies84338592coni_es
coniines10415362coniines
conine84528552conine_
conins84327232conin_s
cosines94122672cosines
crannies10313012crannies
cyanides14258002cyanides
cyanine122911512cyanine_
cyanins122910012cyanin_s
cyanites132610162cyanites
famines123216262famines
fannies103415642fannies
fanzines2036912fanzines
gamines103618462gamines
guanines989772guanines
lawines103313562lawines
malines93625602malines
marines93928012marines
nannies73015202nannies
nines55937342__nines
pannes85522852pan_nes
patines95225762patines
rapines95120862rapines
ratines75328582ratines
ravines104220232ravines
sabines94318482sabines
salines74029412salines
sanies63031952sani_es
savines104417632savines
stanines85115672stanines
vahines133410522vahines
valines104520212valines
venines103516612venines
wahines133111172wahines
zanies153219672zani_es
zaniness1738662zaniness

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711023.44031299.7
3Display Results1021020.0303400.0
 (SQL Overall)1786911023.84346497.8
 
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.