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

66 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
caryotins1424804(None) 
carotins102315581car_otins
carrotins11239961carrotins
caryotin13268351caryotin_
karyotins16234681karyotins
carotids11229942car_otids
carotin92216732car_otin_
carrotin102210892carrotin_
caryatids1545222caryatids
karyotin15194832karyotin_
baryons121010473baryo__ns
barytons1345573bary_tons
canyoning1536873canyoning
canyonings1642873canyonings
canyons124511593canyo__ns
carabins12312353car_abins
carbolics1546723carbolics
carbons115418943carbo__ns
carditis11310223carditi_s
cardons104519933cardo__ns
cardoons113411943cardo_ons
carlins93921913car__lins
carnations12311353carnations
carnitine1178573carnitine
carnitines1277813carnitines
carnotite1147353carnotite
carnotites1246543carnotites
caroling113317003car_oling
caroming133312963car_oming
carotene1039133car_otene
carotenes11410203car_otenes
carotid102014833car_oti_d
carpeting1439483carpeting
carpetings1544213carpetings
carroming1437683carroming
carrotier1146623carrotier
carrotiest1245663carrotiest
carrots9714623carrot__s
carryons1337103carryo__ns
carting104228283car__ting
cartoning12311113cartoning
cartons94122473car__tons
cartoons104012803carto_ons
caryatic1548493caryati_c
caryatid1447953caryati_d
caryatides1644493caryatides
caryopses1645043caryopses
caryopsis1643573caryopsis
ceratins102818733cer_atins
charioting1645723charioting
cortins92421333cor__tins
crayoning1535243crayoning
crayons12439233crayo__ns
creatins103617513c_reatins
cretins93216423c_r_etins
crotons93714373c_r_otons
cryogens1444723c_ryogens
cryonics1555413c_ryonics
cryotrons1444743c_ryotrons
garoting10510703gar_oting
garroting1136953garroting
martins93322063mar__tins
narcotics1374923narcotics
parotids112610413par_otids
parroting1239153parroting
parvolins1486693parvolins

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 Filter1786911486410.420425454.8
2DLD Change Limit148641668.12618292.0
3Display Results66660.0332000.0
 (SQL Overall)178691668.57920828.9
 
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.