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

108 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
clarkia133487(None) 
clarkias1444791clarkias
cardia9916382c_ardia
charka154011702chark_a
charkha19405152charkha
alaska1036713alask_a
aria46245423__ar_ia
calcaria1249543calcar_ia
caldaria1148953caldar_ia
calkin123515493c_alkin
calvaria1347893calvar_ia
cambia124913153c_ambia
cardiac1278823c_ardiac
cardiae10713713c_ardiae
cardias10715123c_ardias
cardio9915673c_ardio
carina84325333c_arina
cark105539273c_ark__
carked134024823c_arked
carking144322853c_arking
carks115534213c_ark_s
carlin84421823c_arlin
carnie84421093c_arnie
carpi94319393c_arpi_
cassia83714763c_assia
catkin123512383c_atkin
ceria75125353c_er_ia
chakra15437533cha_kra
chark144222713chark__
charkas164810963charkas
charked174814013charked
charkhas20285023charkhas
charking183512613charking
charks155219703chark_s
charlie123011923charlie
charpai1436633charpai
clack134720173clack__
clacked164113603clacked
clacker153813773clacker
clacking173313493clacking
clacks144516343clack_s
claim95616913cla__im
clank114719523clank__
clanked143812253clanked
clankier14327083clankier
clanking154313063clanking
clanks124615183clank_s
clanky15469073clank_y
claret84026573clar_et
clarets94111103clarets
claries93422203claries
clarify1536093clarify
clarion9311663clarion
clarity12310913clarity
claro75018693clar__o
claroes93113733claroes
claros84015113clar_os
clary105719613clar__y
classic113710113classic
classis93712723classis
clastic113013963clastic
clavi104912923cla_vi_
cleric10612133cler_ic
clerid9312413cler_id
clerk115812453clerk__
clerked14326653clerked
clerking15257163clerking
clerkish1744263clerkish
clerkly1643573clerkly
clerks12458843clerk_s
clivia1177233cl_ivia
coria75828323c_or_ia
crania82418433cra_nia
curia74523773c_ur_ia
czarina1845953czarina
darkie113714013_darkie
filaria1039653filar_ia
giardia945563giardia
glaikit1244633glaikit
gloria71910553glor_ia
labia75219013_la_bia
lamia75324323_la_mia
lari45839153_lar_i_
lariat6629043_lar_iat
laris54737463_lar_is
lark85733863_lark__
larked114519473_larked
larker104519243_larker
larkier113711523_larkier
larking123718253_larking
larkish1439083_larkish
larks95227813_lark_s
larky125218873_lark_y
larva8312483_lar_va
latakia1146093_latakia
latria62313603_latria
malaria9313703malar_ia
maria75032883_mar_ia
marka114620793_mark_a
markka11416593_markka
parka115120883_park_a
sharia93116733shar_ia
solaria7312493solar_ia
talaria7412523talar_ia
tarsia65514273_tarsia
varia85824203_var_ia
velaria1038923velar_ia
zoaria1548383zoar_ia

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271086.61020276.4
3Display Results1081080.0303600.0
 (SQL Overall)1786911087.06325299.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.