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

185 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
chasmal1415821(None) 
chiasmal15285021chiasmal
casual81112862c_asual
chacma1537902chacma_
chacmas1637992chacmas
chaetal1238282chaetal
chapman1637892chapman
chasm125518792chasm__
chasmed154710172chasmed
chasmic16177982chasmic
chasms135513142chasm_s
chasmy16468542chasm_y
chiasma14366982chiasma_
chiasmas15306582chiasmas
chrismal1575172chrismal
coastal9411032coastal
haemal113811642_haemal
hamal104623102_ha_mal
hammal134512062_hammal
miasmal1176742miasmal
phaseal1245672phaseal
abysmal1453963abysmal
basal75722283_bas_al
bharal1138893bha_ral
cabal95222153c_a_bal
cabman123812503c_abman
caecal103713733c_aecal
caiman103615663c_aiman
camail10314823c_a_mail
camas96333523c_a_mas
camel96822803c_a_mel
canal75428043c_a_nal
cantal84122033c_antal
carman103920743c_arman
carnal83919203c_arnal
carpal103716253c_arpal
casa65630863c_as_a_
casas75327843c_as_as
casbah1337903c_asbah
cashaw14439793c_ashaw
casuals91410523c_asuals
caudal91611483c_audal
causal81413203c_ausal
cayman133613213c_ayman
censual937663censual
ceramal1138843ceramal
chadar1239343cha_dar
chaebol1444943chaebol
chaeta11310683chaeta_
chaetae1238603chaetae
chainman1585173chainman
chairman15106373chairman
chakra15437533chakra_
chakras16428483chakras
chalah143511653cha_lah
chalazal2243873chalazal
challa114014193challa_
challah15458323challah
challas124414123challas
cham115532313cha_m__
chamade15138433cha_made
chammy18488953cha_mmy
champ145017963cha_m_p
champac1834953champac
champak2034493champak
champs154915683cha_mps
champy18509613cha_mpy
chams126028503cha_m_s
chancel144011773chancel
channel123910483channel
chapeau1435523chapeau
chapel134911373cha_pel
chapmen1637283chapmen
charas114223593cha_ras
charcoal15165733charcoal
charisma1576353charisma_
charismas1655293charismas
charka154011703charka_
charkas164810953charkas
charm126124663charm__
charmed154714243charmed
charmer144913663charmer
charms135218833charm_s
charnel124010053charnel
charpai1436623charpai
chase105127123chas__e
chaseable1646343chaseable
chased125019293chas_ed
chaser114918383chas_er
chasers123714893chasers
chases115128233chas_es
chasing133715893chasing
chasse115114603chas_se
chassed134712133chassed
chasses124017503chasses
chassis123910663chassis
chaste114617393chas_te
chastely1635813chastely
chasten124312403chasten
chaster124718503chaster
chasuble1543063chasuble
chateau1236263chateau
chattel12388893chattel
chazan20269133cha_zan
chazzan20204853chazzan
chessman1544823chessman
chiasm13449103chiasm__
chiasmata1643063chiasmata
chiasmi14365573chiasm_i
chiasmic17295013chiasmic
chiasms14357523chiasm_s
chiasmus15343903chiasmus
chimar133911463ch_imar
chimla1337593ch_imla
chiral114614413ch_iral
chisel112111943chis_el
chital114313883ch_ital
chloasma1542963chloasma_
chloasmas1642483chloasmas
chloral12169983chloral
choral115118493ch_oral
chordal13449883chordal
choreal124412223choreal
chorial124214143chorial
chrisma1456823chrisma_
chroma132912473chroma_
chromas142512683chromas
chromyl17275233chromyl
clansman1245813clansman
clausal936273clausal
coaeval1245183coaeval
coaxal15387303coa_xal
coaxial16157003coaxial
comal95125133c__omal
costal85419513c_ostal
craal74117753cra__al
cragsman1345213cragsman
cranial92114683cranial
crestal9312133crestal
crissal937413crissal
crustal939023crustal
crystal1237433crystal
cuspal1037883c_uspal
dharma1276103dharma_
dharmas1356503dharmas
dichasial1544373dichasial
dismal92412243_dismal
gasman92911743_gasman
gharial1137343gharial
hadal95518123_ha_dal
halal85623593_ha_lal
hallal94415563_hallal
halma108219253_halma_
halmas117017893_halmas
hamals114816813_ha_mals
hamaul114210863_ha_maul
hammals14409213_hammals
hammam12419333_hammam
hartal9415473_hartal
hassel95614213_hassel
hazmat20312263_hazmat
hemal104419803_h_emal
hiemal11339493_hiemal
mammal95112753_mammal
miasma1097563miasma_
miasmas1167743miasmas
nasal56217593_nas_al
nasial6413283_nasial
pascal10812373_pascal
phasmid15267603phasmid
phrasal1246163phras_al
plasma103810913plasma_
plasmas113010753plasmas
ramal74622243_ra_mal
rascal8511123_rascal
seismal937303seismal
shaman113314273sha_man
shamas113717933sha_mas
shammas14358713shammas
tamal73522613_ta_mal
thermal125010963thermal
vasal85516293_vas_al
vassal979243_vassal
wadmal1237283_wadmal
yasmak1534593_yasmak

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.1701051123.5
2DLD Change Limit1340271856.87619492.0
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.12225090.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.