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

230 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
chamisa1432885(None) 
camisa103114321c_amisa
chamisas15317791chamisas
chamise143612851chamise
chamiso14348651chamiso
camisas113411922c_amisas
camise103319632c_amise
camisia112810242c_amisia
chais107530312cha_is_
chaise114916412cha_ise
chamises153513312chamises
chamisos15307422chamisos
chamois143512172chamois_
champs154915682champs_
chams126028502cham_s_
charism14712202charism
charisma1576352charisma
chemise143211502chemise
chemism16339302chemism
chemist143615002chemist
chymist17268172chymist
ahimsa1134783ahim_sa
amia66836903__ami_a
amias75831473__amias
amiga85514803__amiga
amis66445323__amis_
amiss75823073__amiss
beamish14259293beamish
cadis84428493c_adis_
calesa8412473c_alesa
camas96333523c_amas_
camass104114183c_amass
cambia124913153c_ambia
cambism1538033c_ambism
cambist13312113c_ambist
camera10313673c_amera
cames97047313c_ames_
camion103917193c_amion
camisade1374823c_amisade
camisado1372943c_amisado
camises114218463c_amises
camisias12268603c_amisias
camos95927613c_amos_
camps116330263c_amps_
cams87047283c_am_s_
capias10318353c_apias
capita102913773c_apita
carina84325323c_arina
casa65630863c_a__sa
casita82913703c_asita
cassia83714763c_assia
ceramist12310933ceramist
chablis14368553chablis_
chachka21173643chachka
chacma1537903cha_cma
chacmas1637993chacmas_
chads116122233cha_ds_
chaeta11310683cha_eta
chafes145017913chafes_
chaffs17459613chaffs_
chafing163911493chafing
chai95929903cha_i__
chain105723673cha_i_n
chaine115119223cha_ine
chains114819703cha_ins
chainsaw1642373chainsaw
chair105519633cha_i_r
chairs114916173cha_irs
chaises124317493cha_ises
chakra15437533cha_kra
chakras16428483chakras
chalaza2145733chalaza
chalice14311043chalice
chalks155412143chalks_
challa114014193cha_lla
challas124414123challas
challis124613463challis_
chalupa1444473chalupa
cham115532313cham___
chamade15138433chamade
chamber164011053chamber
chambray2043133chambray
chamfer17399853chamfer
chammied18215963chammied
chammies172910153chammies
chammy18488953cham_my
chamoised17335323chamoised
chamoises16327933chamoises
chamoix21275623chamoix
champ145017963cham__p
champac1834953champac
champaca1943203champaca
champak2034493champak
champed174111473champed
champer163813403champer
champing183610933champing
champion17276353champion
champy18509613cham_py
changs125215373changs_
chants115020393chants_
chaos105622863cha_os_
chapes135421873chapes_
chaps125326063cha_ps_
charas114223593charas_
chards125119723chards_
chares115631803chares_
charier124317903charier
chariest13315503chariest
charily15310283charily
charing133721323charing
chariot12316213chariot
charismas1655293charismas
charisms15710263charisms
charity15311023charity
charka154011703cha_rka
charkas164810953charkas
charkha19405153charkha
charks155219703charks_
charming163012023charming
charms135218833charms_
charrs115219183charrs_
chars105936633cha_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
chemical1748393chemical
chemics16349573chemics
chemises153211983chemises
chemisms17278213chemisms
chemists152710323chemists
chemos13311723chemos_
cherish15310463cherish
chia96026623ch__i_a
chias104625513ch__ias
chica125818263ch__ica
chilis115517873chilis_
chimbs153910303chimbs_
chimera14389263chimera
chimes134922573chimes_
chiming153311833chiming
chimla1337593chim_la
chimlas1437453chimlas
chimps155713663chimps_
china105022473ch__ina
chis95933313ch__is_
chlamys1733783chlamys_
chomps155112223chomps_
chrism13710673ch_rism
chrisma1456823ch_risma
chumps154313823chumps_
chums125015833chum_s_
chutist1239453chutist
chymes165912153chymes_
chymic18317883chymi_c
chymics19295533chymics
chymists18285603chymists
cladism1238553cladism
cladist10311963cladist
claims105211573claims_
clamps124515083clamps_
clams95127673clam_s_
clayish1547943clayish
coaming123818323coaming
coatis85122593coatis_
cosmism1337013cosmism
cosmist11311333cosmist
cramoisy1543703cramoisy
cramps125615563cramps_
crams96229153cram_s_
crania82418433crani_a
crasis85020473crasis_
czarina1845953czarina
czarism2056423czarism
czarist18710223czarist
famish14311843_famish
ghazis1935193ghazis_
haika125313793_ha_ika
haimish1537753_haimish
hajis156716273_hajis_
hamada1239913_hamada
hames106138703_hames_
hams96446133_ham_s_
hamza19139773_ham_za
hamzas20119013_hamzas
haniwa1236743_haniwa
hansa85416783_ha_nsa
harissa1035503_harissa
khadis1446913khadis_
khakis1265853khakis_
khalifa1742883khalifa
khamsin1643973khamsin
lamia75324323_lami_a
lamias85020613_lamias
lamina84920443_lamina
oghamist1444753oghamist
paisa76021073_pa_isa
phasis114614923phasis_
samosa8510203_samosa
shamas113717933shamas_
shames114726223shames_
shaming133016743shaming
shamisen1344273shamisen
shammas14358713shammas
shamois123210403shamois_
shamos114216983shamos_
shams105829413sham_s_
shamus114112813shamus_
sharia93116723shari_a
sharias102516003sharias
stamina9310793stamina
swamis114212293swamis_
tamis76728723_tamis_
umamis1038273umamis_
whams135515643wham_s_
zamia165115213_zami_a
zamias174212923_zamias

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.1701051123.5
2DLD Change Limit1340272307.98616782.7
3Display Results2302300.0802875.0
 (SQL Overall)1786912308.23621696.3
 
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.