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

100 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
cowinners144413(None) 
cowinner1334751cowinner_
coiners93620752co_i_ners
coinfers13349502co_infers
cointers103616412co_inters
conners94023112co__nners
cosigners1245132cosigners
winners104316912__winners
aginners954623_aginners
beginners1283613beginners
canners93822663c__anners
cinders104617763c__inders
clingers113810663c_lingers
clinkers14339833c_linkers
cocinera1245553coci_nera
cocineras1344963coci_neras
codifiers1555343codifiers
cognizers2164433cognizers
coignes103912153co_igne_s
coilers93619903co_i_lers
coiner84323783co_i_ner_
coinfer12419393co_infer_
coinhere1337133co_inhere
coinheres1447633co_inheres
cointer93616723co_inter_
colanders1238013colanders
combiners15247943combiners
commoners15339783commoners
communers15338413communers
condoners122811513condoners
confers124120093co__nfers
confiners1439953confiners
congeners122511133congeners
congers104223233co__ngers
conifers133611703coni_fers
coniines10415363coniine_s
conines93827793coni_ne_s
conkers133721043co__nkers
conner84423963co__nner_
connivers1436933connivers
consigners1346413consigners
continuers1247943continuers
conveners142911443conveners
convincers1745063convincers
copiers114215963copi__ers
corianders1344893corianders
corners94723313co__rners
corniness112611183corniness
coroners104016223co_roners
cosigner1135953cosigner_
cosines94122673cosi_ne_s
cosiness103214283cosi_ness
cotinines11410073cotinine_s
counters103320193co_unters
cowbanes1537423cowbane_s
cowers114625533cow___ers
cowier113616163cowi__er_
coworkers1854363coworkers
cowriters14317283cowriters
cozeners19297783co_zeners
coziness19319823cozi_ness
cringers112511873c_ringers
crowners133710743crow__ners
cunners93913473c__unners
cylinders1543203cylinders
dinners83915443__dinners
domineers1244673domineers
downers113912773dow__ners
downiness13106713downiness
ginners84314223__ginners
grinners9288043_grinners
howitzers2441853howitzers
inners63919353___inners
joinders16337203jo_inders
joiners144211573jo_i_ners
jointers15289323jo_inters
loriners839963lori_ners
motioners1146573motioners
owners94210703_ow__ners
pinners93518603__pinners
pointers103013723po_inters
rewinders13246503rewinders
sinners74019023__sinners
skinners12347293_skinners
spinners103810863_spinners
swingers123710423_swingers
swinneys14264203_swinneys
thinners11327753_thinners
tinners73717313__tinners
tonners73816403to__nners
twiners10459633_twi_ners
unwinders1343943unwinders
wieners103212483__wieners
wincers123415363__wincers
winders113721263__winders
wingers113921483__wingers
winkers143517113__winkers
winner94219933__winner_
winters103720483__winters
wonners104312813__wonners

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.423422437.4
2DLD Change Limit1486411007.25020502.2
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.70323197.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.