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

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

103 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
clarinets113768(None) 
clarinet10317291clarinet_
clarionets1243901clarionets
cabinets1238282c_abinets
carnets93918402c_ar_nets
chariness14310062chariness
clarets94111102clar__ets
claries93422202clari_e_s
clarinetist1353812clarinetist
clarionet1149832clarionet_
glariness1038552glariness
acarines10314343acarine_s
alanines8314803alanine_s
baronets101410903_baronets
basinets1039063_basinets
blarneys13183193blar_neys
bleariness1246053bleariness
cabinet11318903c_abinet_
caginess11310303c_aginess
cakiness1449553c_akiness
calamines13312223calamine_s
calamints1348053calamin_ts
calcines12314753calcine_s
canines93724033c_anine_s
carbines123617533c_arbine_s
carcanets1347313c_arcanets
carets85330773c_ar__ets
caribes113715643c_aribe_s
carices114220953c_arice_s
caries85147623c_ari_e_s
carinas93622403c_arin_as
carinate103320243c_arinate
carlines103521643c_arline_s
carmines123617863c_armine_s
carnet84732873c_ar_net_
carneys124310543c_ar_neys
carnies94123963c_arnie_s
carpets113915333c_ar_pets
chaines124518733cha_ine_s
chariest13315503chari_est
chariots1339393chari_ots
charnels13328173char_nels
chlorines142512353chlorine_s
chorines132917253chorine_s
citrines102513133citrine_s
cladists1136723cladi_sts
claimers12298743cla_imers
clamminess1643613clamminess
clarences1346453clarences
claret84026573clar__et_
clarifiers1544013clarifiers
clarifies1448633clarifies
clarinetists1452073clarinetists
clarinettist1462243clarinettist
clarioned1245723clarione_d
clarions10310493clari_ons
clarities11312483clarities
clarity12310913clari__ty
claroes93113733clar_oe_s
classiness12196313classiness
claviers1367103clavi_ers
clayiest1337913clayi_est
clearings12286063clearin_gs
clearness1135633clear_ness
clerihews1741553clerihews
clients938093cl__ients
clines84926043cl__ine_s
cornets94820573c_or_nets
coronets103814363c_oronets
craziness2037383craziness
curarines11710553curarine_s
cyanines132710543cyanine_s
czarinas1935293czarin_as
czarists1966223czari_sts
flakiness1636473flakiness
flamines13311643flamine_s
flavines1437893flavine_s
garnets84115403_gar_nets
glariest92012523glari_est
glaziness1935753glaziness
hairnets1195633_hairnets
hoariness1238823hoariness
laciness102112553_laciness
lariats7615053_lari_ats
larine63927043_larine__
larkiness1338113_larkiness
latrines8515003_latrine_s
lawines103313563_lawine_s
laziness17239983_laziness
loriners839963_loriners
mariners103113863_mariners
marines93928013_marine_s
martinets1138883_martinets
plainest10313613pla_inest
plaints94012053pla_in_ts
planets93914083pla__nets
sarsnets836783_sarsnets
satinets8311733_satinets
scariness11310183scariness
slatiness92511363slatiness
teariness9310633teariness
wariness11313213_wariness
weariness1238843weariness

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.420425454.8
2DLD Change Limit1486411037.50019818.8
3Display Results1031030.0502060.0
 (SQL Overall)1786911037.97022420.5
 
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.