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

115 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
chamisos1530742(None) 
chamisas15317811chamisas
chamises153513311chamises
chamiso14348651chamiso_
camisas113411922c_amisas
camises114218462c_amises
chaises124317492cha_ises
chamisa14328852chamis_a
chamise143612852chamis_e
chamoises16327932chamoises
charisms15710262charisms
chemises153211982chemises
chemisms17278212chemisms
chemists152710322chemists
chymists18285602chymists
amigos94511213__amigos
amiss75823073__amis_s
avisos95410483__avisos
calicos113913493c_alicos
camases114216343c_amases
camass104114183c_amas_s
cambisms1645803c_ambisms
cambists1437023c_ambists
cameos105818003c_am_eos
camion103917193c_ami_on
camions113916133c_amions
camisa103114323c_amis_a
camisados1472563c_amisados
camise103319633c_amis_e
camisia112810243c_amisia
camisias12268603c_amisias
camisole1246173c_amisole
camisoles1345583c_amisoles
camos95927613c_am__os
campos125217953c_am_pos
cansos84915383c_a_nsos
casinos93512833c_asinos
ceramists1346723ceramists
chaines124518733cha_ines
chains114819703cha_i_ns
chairs114916183cha_i_rs
chais107530313cha_i__s
chaise114916413cha_is_e
chalices15310813chalices
challises14358783challises
chamades16138653chamades
chambers173410623chambers
chamfers18409223chamfers
chamfron1844493chamfron
chamfrons1944383chamfrons
chammies172910163chammies
chamois143512193cham_ois
chamoised17335323chamoised
champacs1934633champacs
champaks2134103champaks
champers173311623champers
champion17276353champion
champions18875783champions
champs154915683cham__ps
chams126028503cham___s
chanson1238043cha_nson
chansons1337473cha_nsons
chaos105622863cha___os
chaoses124715123cha_oses
charases131312763charases
chariot12316213chari_ot
chariots1339393chariots
charism14712203charis_m
charisma1576363charisma
charismas1655313charismas
charros124312143cha_rros
chartists14126803chartists
chases115128233cha__ses
chasings14318253chasings
chasms135513143cha__sms
chasses124017503cha_sses
chassis123910663cha_ssis
chastises1437703chastises
chausses1345963chausses
chemics16349583chemi_cs
chemise143211503chemis_e
chemism16339303chemis_m
chemisorb1853413chemisorb
chemisorbs1972333chemisorbs
chemist143615003chemis_t
chemos13311723chem__os
chicos134614833ch__icos
chinos115018693ch__inos
chiros114617773ch__iros
chlamyses1962493chlamyses
chorizos2245493chorizos
chrisms1499143ch_risms
chrisom1466623ch_risom
chrisoms1566093ch_risoms
chutists1335583chutists
chymics19295533chymi_cs
chymist17268173chymis_t
cladisms1336093cladisms
cladists1136723cladists
coamings13349293coamings
cosmisms1446223cosmisms
cosmists1237993cosmists
crambos1336783cram_bos
czarisms2155753czarisms
czarists1966223czarists
khamsins1743393khamsins
misos76523293___misos
oghamists1543033oghamists
shamisen1344273shamisen
shamisens1442603shamisens
shammos14307203sham_mos
shamos114216983sham__os
shampoos1544603shampoos
shamuses1336153shamuses
tamises92715973_tamises

Search took 10 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.830215290.4
2DLD Change Limit1461621158.46617264.6
3Display Results1151150.0502300.0
 (SQL Overall)1786911159.34619119.5
 
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.