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

136 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
chamisas1531781(None) 
camisas113411921c_amisas
chamisa14328851chamisa_
chamises153513311chamises
chamisos15307421chamisos
camisa103114322c_amisa_
camises114218462c_amises
camisias12268602c_amisias
chaises124317492cha_ises
chamise143612852chamis_e
chamiso14348652chamis_o
chamoises16327932chamoises
charismas1655312charismas
charisms15710262charisms
chemises153211982chemises
chemisms17278212chemisms
chemists152710322chemists
chymists18285602chymists
ahimsas1234783ahim_sas
amias75831473__ami_as
amigas95912173__amigas
amiss75823073__amis_s
calesas9411833c_alesas
camas96333533c_am__as
camases114216343c_amases
camass104114183c_amas_s
cambisms1645803c_ambisms
cambists1437023c_ambists
cameras11313363c_ameras
camions113916133c_amions
camisade1374823c_amisade
camisades1474963c_amisades
camisado1372943c_amisado
camisados1472563c_amisados
camise103319633c_amis_e
camisia112810243c_amisia
capias10318353c_api_as
carinas93622423c_arinas
caritas93316963c_aritas
casas75327843c_a__sas
casitas93312043c_asitas
cassias93514343c_assias
ceramists1346723ceramists
chachkas22173733chachkas
chacmas1638003cha_cmas
chaines124518733cha_ines
chains114819703cha_i_ns
chainsaw1642373chainsaw
chainsaws1742263chainsaws
chairs114916183cha_i_rs
chais107530313cha_i__s
chaise114916413cha_is_e
chakras16428503cha_kras
chalazas2245893chalazas
chalices15310813chalices
challas124414123cha_llas
challises14358783challises
chalupas1554383chalupas
chamades16138653chamades
chambers173410623chambers
chambray2043143chambray
chambrays2142423chambrays
chamfers18409223chamfers
chammies172910163chammies
chamois143512193cham_ois
chamoised17335323chamoised
champac1834953cham_pac
champacas2042963champacas
champacs1934633champacs
champak2034493cham_pak
champaks2134103champaks
champers173311623champers
champions18875783champions
champs154915683cham__ps
chams126028503cham___s
chaoses124715123cha_oses
charas114223613cha__ras
charases131312763charases
chariots1339393chariots
charism14712203charis_m
charisma1576363charisma
charkas164810963cha_rkas
charkhas20285023charkhas
chartists14126803chartists
chases115128233cha__ses
chasings14318253chasings
chasms135513143cha__sms
chasses124017503cha_sses
chassis123910663cha_ssis
chastises1437703chastises
chausses1345963chausses
chemical1748393chemical
chemicals1845603chemicals
chemics16349583chemi_cs
chemise143211503chemis_e
chemism16339303chemis_m
chemist143615003chemis_t
chias104625523ch__i_as
chicas135916473ch__icas
chimeras15388833chimeras
chimlas1437453chim_las
chinas115119403ch__inas
chlamyses1962493chlamyses
chrisms1499143ch_risms
chutists1335583chutists
chymics19295533chymi_cs
chymist17268173chymis_t
cladisms1336093cladisms
cladists1136723cladists
coamings13349293coamings
cosmisms1446223cosmisms
cosmists1237993cosmists
czarinas1935303czarinas
czarisms2155753czarisms
czarists1966223czarists
hamadas1339673_hamadas
hamzas20119013_ham_zas
hansas94616043_ha_nsas
harissa1035503_harissa
harissas1145983_harissas
khalifas1842513khalifas
khamsins1743393khamsins
lamias85020613_lami_as
laminas93615873_laminas
oghamists1543033oghamists
paisas84317493_pa_isas
samosas939303_samosas
shamas113717943sham__as
shamisen1344273shamisen
shamisens1442603shamisens
shammas14358723sham_mas
shamuses1336153shamuses
sharias102516003shari_as
staminas1048853staminas
tamises92715973_tamises
zamias174212923_zami_as

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621366.75021653.6
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.