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

203 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
chamiso1434865(None) 
chamisa14328851chamisa
chamise143612851chamise
chamisos15307421chamisos
camisa103114322c_amisa
camise103319632c_amise
chais107530312cha_is_
chaise114916412cha_ise
chamisas15317812chamisas
chamises153513312chamises
chamois143512192chamois_
champs154915682champs_
chams126028502cham_s_
charism14712202charism
chemise143211502chemise
chemism16339302chemism
chemist143615002chemist
chymist17268172chymist
amido85720983__amido
amigo86515473__amigo
amino75425503__amino
amis66445323__amis_
amiss75823073__amiss
aviso85713963__aviso
beamish14259293beamish
cadis84428503c_adis_
calico103414433c_alico
camas96333523c_amas_
camass104114183c_amass
cambism1538033c_ambism
cambist13312113c_ambist
cameo95924993c_am_eo
cameos105818003c_ameos
cames97047313c_ames_
camion103917193c_amion
camisado1372943c_amisado
camisas113411923c_amisas
camises114218463c_amises
camisia112810243c_amisia
camisole1246173c_amisole
camo85731753c_am__o
camos95927613c_amos_
campo115219763c_am_po
campos125217953c_ampos
camps116330263c_amps_
cams87047283c_am_s_
canso75019403c_a_nso
casino84317553c_asino
ceramist12310933ceramist
chablis14368563chablis_
chacmas1638003chacmas_
chads116122233cha_ds_
chafes145017913chafes_
chaffs17459613chaffs_
chafing163911493chafing
chai95929903cha_i__
chain105723673cha_i_n
chaine115119223cha_ine
chains114819703cha_ins
chair105519633cha_i_r
chairs114916183cha_irs
chaises124317493cha_ises
chalice14311043chalice
chalks155412143chalks_
challis124613463challis_
cham115532313cham___
chamade15138453chamade
chamber164011063chamber
chamfer17399863chamfer
chamfron1844493chamfron
chammied18215973chammied
chammies172910163chammies
chammy18488953cham_my
chamoised17335323chamoised
chamoises16327933chamoises
chamoix21275643chamoix
champ145017963cham__p
champac1834953champac
champak2034493champak
champed174111483champed
champer163813413champer
champing183610933champing
champion17276353champion
champy18509613cham_py
changs125215373changs_
chanson1238043cha_nson
chants115020393chants_
chao95727313cha___o
chaos105622863cha_os_
chapes135421873chapes_
chaps125326063cha_ps_
charas114223613charas_
chards125119733chards_
chares115631803chares_
charier124317903charier
chariest13315503chariest
charily15310283charily
charing133721323charing
chariot12316213chariot
charisma1576363charisma
charisms15710263charisms
charity15311023charity
charks155219703charks_
charming163012033charming
charms135218843charms_
charro114212953cha_rro
charros124312143charros
charrs115219193charrs_
chars105936643cha_rs_
chartist131112133chartist
charts115823093charts_
chase105127123cha__se
chases115128233chases_
chasing133715893chasing
chasm125518793cha__sm
chasmic16177983chasmi_c
chasms135513143chasms_
chasse115114603cha_sse
chassis123910663chassis
chastise1348173chastise
chats105730093cha_ts_
chawing164813033chawing
chaws135022463cha_ws_
chays135319743cha_ys_
cheapish1844333cheapish
chemic153012093chemi_c
chemics16349583chemics
chemises153211983chemises
chemisms17278213chemisms
chemisorb1853413chemisorb
chemists152710323chemists
chemo12313633chem__o
chemos13311723chemos_
cherish15310463cherish
chiao105618363ch__iao
chico124218253ch__ico
chilis115517873chilis_
chimbs153910303chimbs_
chimes134922573chimes_
chiming153311833chiming
chimps155713663chimps_
chino105823313ch__ino
chiro105320343ch__iro
chis95933313ch__is_
chlamys1733783chlamys_
chomps155112223chomps_
chorizo2136323chorizo
chrism13710673ch_rism
chrisom1466623ch_risom
chumps154313823chumps_
chums125015833chum_s_
chutist1239453chutist
chymes165912153chymes_
chymic18317883chymi_c
chymics19295533chymics
chymists18285603chymists
cladism1238553cladism
cladist10311973cladist
claims105211573claims_
clamps124515083clamps_
clams95127673clam_s_
clayish1547943clayish
coaming123818323coaming
coatis85122603coatis_
cosmism1337013cosmism
cosmist11311333cosmist
crambo1238043cram_bo
crambos1336783crambos
cramoisy1543703cramoisy
cramps125615563cramps_
crams96229153cram_s_
crasis85020473crasis_
czarism2056423czarism
czarist18710223czarist
famish14311843_famish
ghazis1935203ghazis_
haimish1537753_haimish
hajis156716283_hajis_
hames106138703_hames_
hams96446133_ham_s_
khadis1446913khadis_
khakis1265853khakis_
khamsin1643983khamsin
miso67229903___miso
oghamist1444753oghamist
phasis114614923phasis_
shamas113717943shamas_
shames114726223shames_
shaming133016743shaming
shamisen1344273shamisen
shammos14307203shammos
shamois123210423shamois_
shamos114216983shamos_
shampoo1435373shampoo
shams105829413sham_s_
shamus114112813shamus_
swamis114212293swamis_
tamis76728733_tamis_
umamis1038273umamis_
whammo16405193wham_mo
whamo135511263wham__o
whams135515643wham_s_
whomso1434133whom_so

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 Filter1786911340270.843211970.3
2DLD Change Limit1340272037.15618729.3
3Display Results2032030.0633222.2
 (SQL Overall)1786912038.06222164.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.