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

63 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
coanchors164573(None) 
coanchor1545251coanchor_
anchors123912952__anchors
coachers154312302coa_chers
coactors1239482coa_ctors
coanchored1843272coanchored
coauthors1444312coauthors
conchos144313962co_ncho_s
unanchors1442612unanchors
anchor113911973__anchor_
anchos114214893__ancho_s
blanchers16307433blanchers
cachous14312583c_a_chous
camphors1737053c_amphors
cancers114018583c_anc_ers
canchas143212403c_anch_as
candors104216763c_an_dors
canephors1644763c_anephors
cantors94620753c_an_tors
catchers153114063c_atchers
chancers154313493chanc_ers
chancrous1644873chancrous
chantors133710263chan_tors
clangors11417003clan_gors
clenchers16276553clenchers
clinchers16336263clinchers
coacher143714123coa_cher_
coaches144018693coa_ch_es
coachwork2343283coa_chwork
coachworks2443063coa_chworks
coactor1139133coa_ctor_
coanchoring1943243coanchoring
coauthor1343463coauthor_
coenamors1344703coenamors
cofactors1645943cofactors
conchas144013313co_nch_as
conches144019813co_nch_es
conchies153214853co_nchies
concho134414263co_ncho__
conchoid1688043co_nchoid
conchoids1766273co_nchoids
conchs134714903co_nch__s
concord12510343co_nc_ord
concords1358593co_nc_ords
concours1239473co_ncours
concurs11311473co_nc_urs
condors104018573co_n_dors
connectors1448183connectors
corncobs1444723cornc_obs
cornichons1743153cornichons
couchers153513863co_uchers
councilors1443253councilors
cranches153114543cranch_es
crunchers16316243crunchers
honchos15369573ho_ncho_s
nonactors1147883nonactors
poachers152910763poa_chers
ponchos143410703po_ncho_s
ranchers133311793_ranchers
ranchos123911393_rancho_s
rancors9811373_ranc_ors
stanchers14206813stanchers
unanchor1343093unanchor_

Search took 8 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 Filter1786911486410.440406115.9
2DLD Change Limit148641636.95321378.0
3Display Results63630.0302100.0
 (SQL Overall)178691637.42324072.6
 
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.