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

165 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
caviares133799(None) 
caviare1238371caviare_
caviars1238621caviar_s
aviaries1139782_aviaries
aviates10313062_aviates
calibres1237102calibres
capiases1239252capiases
carfares13310322carfares
caviar11310162caviar__
cavies114525002cavi__es
cavilers1348112cavilers
cavitates14168962cavitates
cavities131412612cavities
acariases1146613acariases
aliases7914493_aliases
apiaries10312733_apiaries
avgases11106313_avgases
avians93711563_avia_ns
aviarist11410113_aviarist
aviary12338413_aviar_y
aviate9315203_aviate_
aviated11310263_aviated
aviatress1242433_aviatress
barwares13610093barwares
cabaret112519043ca_baret
cabarets12268463ca_barets
cabbages1537203cabbages
caciques21165373caciques
cadres94017933ca__dres
caesars9410733caesar_s
cahiers123510673cahier_s
caiques18248793ca_iques
cairds96411513ca_i_rds
cairns85313303ca_i_rns
calcars11312653calcar_s
calibers1238523calibers
calibre1136603calibre_
calibred1335053calibred
calices114321693cali_ces
caliches153812273caliches
calicles123811433calicles
calicoes123911603calicoes
califates14310113califates
calipees1247413calipees
calipers1249443calipers
calvaries1449803calvaries
calvities1438943calvities
camases114216343ca_mases
camisades1474963camisades
camises114218463cami_ses
canapes111213083ca_napes
canards10311203ca_nards
canaries10318943ca_naries
canewares1447363canewares
canines93724033cani_nes
canities101519263canities
canvases13349523canvases
capias10318353capia__s
capizes20410373capi_zes
captures1239443captures
carafes125015703ca_rafes
carates95630613ca_rates
carbarns1238563carbarns
carcases12313093carcases
cares77369183c___ares
carfare12310073carfare_
caribes113715643cari_bes
carices114220953cari_ces
caries85147623cari__es
carioles10817073carioles
caritases1139763caritases
carnages11312213carnages
carriages1238333carriages
cartages11313313cartages
cascades13128553cascades
cascaras1237703cascaras
caseases10410473caseases
caseates10313713caseates
casimeres1355193casimeres
casimires1344693casimires
catfaces1536963catfaces
catharses1446413catharses
caudates11310263caudates
cavalries1446363cavalries
caveated1439133caveated
caveats1239803cavea_ts
caverns124510253cav_erns
cavers115026843cav_er_s
caves105639703cav___es
cavie104621593cavi__e_
caviled1348723cavi_led
caviler1249063cavi_ler
cavilled1436733cavilled
caviller1337063caviller
cavillers1435613cavillers
cavils114014393cavi__ls
cavings134712543cavi_ngs
cavitary1664963cavitar_y
cavitate13159833cavitate_
cavitated15177353cavitated
cavitied14126813cavitied
cavorts1237933cav_orts
caziques28193773caziques
centares102913893centares
centiares1167653centiares
ceviches1834843ceviches
chares115631803c__hares
chirres123812253c_hirres
chivaree1646363chivaree
chivarees1744383chivarees
chivaries1757433chivaries
ciliates10413453ciliates
cires74932913c__i_res
civies114116443civi__es
clavicles1643673clavicles
claviers1367103clavier_s
claywares1743463claywares
compares143816433compares
covaries13413253cov_aries
craniates11310653craniates
curares94916853c_urares
davies105020513davi__es
daycares1454803daycares
daymares1445333daymares
deciares11510633deciares
deviates12312733deviates
fanfares1436773fanfares
gavages1237683gav_ages
gavials1136603gavia_ls
haviors1347383havior_s
labiates101011513labiates
laniards967313laniards
laniaries9411223laniaries
lavages1138603lav_ages
lavishes1457403lavishes
mavies114923193mavi__es
mavises122812993mavi_ses
naiades838213na_iades
navars92810573nav_ar_s
navies95218623navi__es
navigates1345873navigates
obviates1345153obviates
pavanes123612653pav_anes
paviors1237603pavior_s
pavisers13387443pavisers
pavises125315493pavi_ses
pavisses13397103pavisses
radiates92415293radiates
ravages1139403rav_ages
ravines104220233ravi_nes
ravishes1478043ravishes
rivieres1136013rivieres
satiates8314633satiates
satires72617573sati_res
savages1139973sav_ages
savates10312953sav_ates
savines104417633savi_nes
saviors1058993savior_s
scalares103210983sca_lares
variates111214983variates
vires84529683__vi_res
warfares1436683warfares
wavicles1633783wavicles
wavies125019843wavi__es
zaires1539703za_i_res

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 Limit1461621656.95321021.4
3Display Results1651650.0632619.0
 (SQL Overall)1786911657.45223978.9
 
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.