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

111 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
charkha1940515(None) 
charka154011701chark_a
charkhas20285021charkhas
chachka21173642chachka
chakra15437532cha_kra
chark144222712chark__
charkas164810962charkas
charked174814012charked
charks155219702chark_s
clarkia1334872clarkia
bhakta1533653bha_kta
cancha134411613c_ancha
cardia9916383c_ardia
carina84325333c_arina
cark105539273c_ark__
carked134024823c_arked
carks115534213c_ark_s
chachkas22173733chachkas
chacma1537903cha_cma
chaeta11310683cha_eta
chakras16428503chakras
chalah143511663chalah_
chalahs15289883chalahs
chalaza2145733chalaza
chaleh143711993chaleh_
chalehs15268803chalehs
chalk144814603chalk__
chalked17449863chalked
chalks155412143chalk_s
chalky18468773chalk_y
challa114014193cha_lla
challah15458323challah
chalupa1444473chalupa
chamisa14328853chamisa
char95132153char___
charade13129913charade
charas114223613char_as
charcoal15165743charcoal
chard116124743char__d
chards125119733char_ds
chare105231983char__e
chared125423693char_ed
chares115631803char_es
charge125114213char_ge
charged144614023charged
charger133914063charger
charges134615983charges
charier124317903charier
charily15310283charily
charing133721323charing
chariot12316213chariot
charism14712203charism
charisma1576363charisma
charity15311023charity
charking183512613charking
charley15118273charley
charlie123011923charlie
charm126124663char__m
charmed154714253charmed
charmer144913663charmer
charms135218843char_ms
charnel124010053charnel
charpai1436633charpai
charpoy1735713charpoy
charqui2144003charqui
charr104821783char__r
charred134614483charred
charro114212953char_ro
charros124312143charros
charrs115219193char_rs
charry145012113char_ry
chars105936643char__s
chart105038283char__t
charted135116853charted
charter123918303charter
charts115823093char_ts
chary135023133char__y
chatchka22202893chatchka
chirk144516183chirk__
chirked173810333chirked
chirker16429323chirker
chirks155414843chirk_s
chorea115216093chor_ea
chroma132912473ch_roma
chukka1433013ch_ukka
church1636483church_
churchy2044183churchy
clarkias1444793clarkias
czarina1845953czarina
dharma1276103dhar_ma
dharna1055263dhar_na
haha107821063_ha__ha
haika125313793_haik_a
halakha17416593_halakha
hardhat14411023_hardhat
hark115237393_hark__
harked145422553_harked
harken135116343_harken
harks126333433_hark_s
harsh116418053_harsh_
khirkah1641433khirkah
marka114620793_mark_a
markka11416593_markka
parka115120883_park_a
shadkhan1942083shadkhan
sharia93116733shar_ia
shariah132210533shariah
shark126225023shark__
sharked153613913sharked
sharker144313813sharker
sharks135019723shark_s

Search took 7 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.406440125.6
2DLD Change Limit1340271115.79623124.1
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.24828599.7
 
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.