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 “caciques” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
caciques2116537(None) 
cacique20205691cacique_
caiques18248791ca_iques
caziques28193771caziques
caciquism2452232caciquism
caique17318802ca_ique_
calques182710192ca_lques
casques18278982ca_sques
cazique27194032cazique_
cliques18309202c_liques
laliques1744832laliques
macaques2143952macaques
sacques18106862sac_ques
accidies1338043accidies
accrues1135323_accrues
acinus8311253_acinu_s
acquest1837173_ac_quest
antiques1738883antiques
baroques1934863baroques
barques18259643ba_rques
basques18248673ba_sques
beziques2843213beziques
caches137926913cac__hes
cachous14312583cachou_s
caciquisms2551853caciquisms
cackles153717203cac_kles
cactus104912233cac_tu_s
cactuses1237933cactuses
calcifies1638923calcifies
calcifuges1852073calcifuges
calcines12314753calci_nes
calcites12313003calci_tes
calciums1446163calci_ums
calibres1237103calibres
calices114321693cali_ces
caliches153812263caliches
calicles123811433calicles
calicoes123911593calicoes
calipees1247413calipees
calque17289843ca_lque_
calqued19306523ca_lqued
camises114218463cami_ses
cangues10611823ca_ngues
canines93724033cani_nes
canities101519263canities
capiases1239253capiases
capizes20410373capi_zes
caribes113715643cari_bes
carices114220953cari_ces
caries85147623cari__es
carioles10817073carioles
carious93320283cariou_s
casque17299273ca_sque_
casqued19235633ca_squed
caviares1337993caviares
cavies114525003cavi__es
cavities131412613cavities
cecities12312043cecities
cheques2136863c_heques
cinques1837333c_inques
cirques1836463c_irques
claques18279013c_laques
clique17289193c_lique_
cliqued19266683c_liqued
cliquey21295693c_liquey
cloques18268563c_loques
copihues1543993copihues
critiques2042593critiques
dacites101114593daci_tes
facies113921593faci__es
fatigues1244193fatigues
fiques1837973__fiques
garigues1034953garigues
habitues13306413habitues
lacquer18135153lac_quer
lacquers19125033lac_quers
lacquey21143803lac_quey
lacqueys22132693lac_queys
lalique1644423lalique_
macaque2044053macaque_
marques182610863ma_rques
masques18239363ma_sques
obliques1944513obliques
pacifies15311223pacifies
periques1937653periques
piques1739093__piques
pratiques20114213pratiques
racquet1838743rac_quet
racquets1944763rac_quets
reliques1736903reliques
sacque17107113sac_que_
siliques1745353siliques
uniques1667443_uniques

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.453394461.4
2DLD Change Limit146162937.47019566.5
3Display Results93930.0462021.7
 (SQL Overall)178691937.96922423.3
 
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.